DAX Fridays! #8: CALCULATE (Part 2)

The calculate function is the most useful measure available in DAX. Let's go through how it works in this part 2!

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

ABOUT CURBAL:

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
► Twitter: @curbalen, @ruthpozuelo

#DAXFRIDAYS #CURBAL #DAX #POWERBI #MVP

[shashindulakshitha]

Thank you very much Curbal. Your channel is one of the best channels for someone to learn on PowerBI and DAX. Hoping to see your channel with more awesome videos.

[MichaelBrown-lwkz]

Excellent, I have been studying the the CALCULATE function all week and you validated my understanding of it. Thank you so much

[Bismillah]

Great videos, I am building up my DAX knowledge thanks to these. Thank you for continuing this series!

[gustavotpb]

Thank you very much, with videos 5, 6 and 8 of the series "DAX Fridays!" are perfect.
You're great!

Thank you, thank you and thank you!

[davidr.]

Hola Ruth! I love your constant ads for Queso Cabrales :-D (and your videos). Thanks for your work!

[jn]

The video is great, do you have any course about DAX formula?

[yugandharb]

Million Thanks... You saved my time and hard analysis. Your videos are meaningful. Thanks.👍👍

[shohruxislomov]

where can we find the files used in the video

[deepakkanade]

Hey Ruth. Both the parts of Calculate() are just WOW !!. Your way of explanation is very simplistic. I could very easily understand all the functions from #2 through #8 and could implement it in my test models, as the test data I am using is different from yours. Looking forward to going through all the further videos. These all will be equally elaborate and educative, I am sure. Thanks a lot !! _/\_

[bhagisrivally]

hi ruth.. Im getting same type of values in cal with 2 cond and cal with filter

[GagandeepSingh-dbeh]

Hi Ruth, what it make any difference If I use keepfilters.

[maryamseidnejad]

Hi, your videos are great. I am learning a lot from them and on my pace .

[keithaa]

I would love to see Calculate #3 and #4...

Perhaps how it helps with Filter vs ROW context, how it works with other measures and some advanced queries.

[eriol]

this is a very good introduction video. I have been trying to understand calculate for a while. I am going to try this on my work soon.

[Rafian]

Thanks a lot, you helped us to skill up and learn more. Could you please make a video on a dashboard which covers many important dax functions and help us to give the handson on real project?

[tymothylim]

Hello! Thank you for another video :) This video was really helpful. I like how you used Dax Studio to show us the table produced by Filter(). Thank you again for the help!

[Dipakbohora]

To filter the report by calendar, is it necessary to have calendar in separate sheets or we can filter it from single sheet? I mean If I want to view the report by Year/Months, is it necessary to have the calendar in separate sheet or we can filter it from the same sheet where Sales Figure & Calendar are available in the same sheet?

[evaism]

I'm watching this 11:42 PM, and I can't really wrap my head around the FILTER function used as [filter] argument of the CALCULATE function. Does the behavior have anything to do with the relationship between FilteredProductsTable and Order_Detail?

[NorbertoVeraReatigaNVR]

Hola Ruth!!... Muchas gracias, excelente explicación.

[narianu]

The video is very helpful to understand the basics of the CALCULATE function but I'd like to see more specific real-world examples of how you'd use it. In other words, what would be some analysis that you can only do with the calculate function?