Power BI DAX: How to Use the CALCULATE Function

✅This Power BI tutorial was taken from the full, Power BI course available on Simon Sez IT

In this Power BI DAX Tutorial, we look at how to use the CALCULATE function in Power BI Desktop.

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[patticmcconnell]

A favourite presenter! Always making it easy to understand. Clear & concise :)

[kiwirafael]

Hello, how are you? I'm Brazilian and I'm really enjoying your videos, especially those that talk about Power Query. Thank you very much for the content.

[UlyssesHaq]

Simon Sez IT.... and I myself Doez IT.... thank you kindly. Impeccable as always.

[EFox]

Great video, very clear! One question though, if I wanted to have the filter argument be an 'either this value OR this other value', whats the best way? So for your example something like =CALCULATE([TotalRevenue], [Category]= "Food" or "Pastries")

[kebincui]

thanks for your clear presentation👍🏻👍🏻👍🏻

[theindiandataanalyst]

The simple definition of the calculate function - it changes row context to filter context.

[philipmathew]

Great....do you have a video on converting dates to weekdays and weekends....many thanks.

[himanshujumnani]

Can calculate Function be used when creating Measures or Calculated Fields ?

[blueguy]

Thanks for this. This is exactly what I needed to do. À kind of sumif.