CALCULATE, CALCULATETABLE - DAX Guide

CALCULATE: Evaluates an expression in a context modified by filters.

CALCULATETABLE: Evaluates a table expression in a context modified by filters.

This video is part of DAX Guide, the online guide to all the DAX functions, with links to related content and compatibility matrix with all the versions of Power BI, Azure Analysis Services (AAS), SQL Server Analysis Services (SSAS), SQL Server Data Tools (SSDT), and Power Pivot for Excel.


#dax #powerbi #ssas #tabular #analysisservices #powerpivot

[peterbogdanovich]

Finally all the secrets of Calculate in one place, Bravo!

[esmaelawad]

I love this man what a great explanation
but I surely love to hear him say FILTER CONETEXTA

[gourisankart]

Never missing the videos now a days to watch it to gain knowledge. Appreciate your effort sir.

[NottoriousGG]

This is what mastery sounds like. Thank you

[ikark]

Great video! Thank you for comprehensive explanation 👍❤️

[qaiserelahi]

Dear Marco, Thanks for sharing your knowledge and expertise with us. Please help me solve one question if I want to find out the comparison of sales of current month v/s last month to find out who my new customers and who are the customers who didn't purchase this month from the sales table.

[nebulaable]

what i have seen ? Brilliant... like found the path to enlightenment.. wow!

[DevilGoncalo]

Thank you for the videos, you and Marco are excellent teachers! This video helped me a lot!

[MatthiasK-qpbf]

totally logical and very well presented :-) thx for this video

[lbarbyery]

Thanks to share all details about CALCULATE func. This is the fist time that a see se sequance o execution and I have a question. Why the evaluation are separeted of application of filters?

[shailendrarajput]

Very good summary video indeed, specially order of execution section, thank u so much ....all clear but a request, can we have one visual section with example on order of execution the way you have visually explained in arbitrary shaped filter video ...it will be really helpful for all

[leonardobrondani]

Excelente explicación!! muchas gracias

[princewable]

Hi, Alberto. Great video. I just have a request..Can you please provide the list of global & local modifiers used in CALCULATE function?

[nigeltufnel]

Gonna get picky here. Can you add the [year] to the output table?

Otherwise, always enjoy your content!

[FredBagola]

Hello Alberto, how are you? Great video, as always. Congratulations! I was left with a doubt: you said that every measure has a CALCULATE and also said about the order of evaluation of CALCULATE's arguments. Why in a row context do I get different results using a ready measure than writing CALCULATE directly? Example:


DEFINE

MEASURE Sales[# Color] =
CALCULATE(
COUNTROWS(VALUES(Product[Color])),
VALUES(Product[Color])
)

EVALUATE
ADDCOLUMNS(
VALUES(Product[Color]),
CALCULATE ( COUNTROWS ( VALUES ( Product[Color] ) ), VALUES( Product[Color] ) ),
"@[Measure]",
[# Color]
)

[AgulloBernat]

Thank you so much for this video. When applying a simple filter, CALCULATETABLE is the same as FILTER? As intermediate step on a calculated table I've had some issues with CALCULATETABLE that disappeared using FILTER

[Tommietusindbuks]

Hi
when do I know if the result is a scaled value or a table?
Thanks
/Thomas

[odeddror]

Is there any way you can show in your video what is after the evaluate line or if you can drop this example for download? please

[bandaralqahtani]

Hi Alberto l,
What is the porpuse of "Calculate table" if we can do the same work with "Filter" function?

[syedhabeeb]

How to create a dax measure where individual rows it should calculate ratio and total should be sum of all the records visible ??