Using calculation groups in DAX

This session introduces calculation groups, when they should be used and several examples of use cases. You will also learn how calculation groups work internally and what are the limits of this amazing tool.

Tags: Developing,On-prem,Cloud,Power BI,Power BI Embedded

[markhenderson]

Thank you for going into so much detail. I watched several other videos on calculation groups and yours dug a lot deeper. Great to see.

[pupycron]

This is excellent. The explanation of WHY things work how they work is not easy to come by. It helps to understand how to do things before I learn it wrong!

[DeronHuskey]

This was a very valuable video to me. Thank you for taking the time to explain the issues surrounding this feature.

I'm looking forward to using this in my models.

[gueszka]

Hi Alberto, I experienced much better performance with calculation groups instead of using switch with huge data models. I assume that switch evaluates all the nested measures but I haven't found any documentation to backup my thought. What do you think is there a significant difference in terms how the engine works with CG and Switch?

[Psyresidente]

Hi Alberto, great explanation. In my case I would like to calculate MTD, QTD, YTD, Current and prev FISCAL YEAR... In all these that are not allowed to do it using time Intelligent cause the Fiscal YEAR starts in September. How is the best way to achieve this? I think I have an idea case In my calendar date table I have columns that identify those times with strings but I want to know if there is a easier way. Thanks !

[bandaralqahtani]

Thanks, Alberto,
do you have workshops only for DAX functions and hands-on projects?

[DavidPesante]

Is there a video like this but for how to use the new Field Parameters feature in DAX?

[schenas]

sarebbe bello poter vedere i tuoi video Alberto ferrari in lingua italiana complimenti per la tua professionalità esiste un corso fatto da te da acquistare su power bi in italiano ?

[Kenayi]

Hi Alberto, which of your Udemy courses correctly represent your green Business Analysis Book on Amazon please? I plan to buy both

[renusharmadhoundiyal]

I have 4 pricing type 12 sales total - Contract, Standard, buyin, Override. We want to see sales impact by price increase 1%, 1.5%, 2% and so on. but want to exclude buyin and override from calculating but they should return 12 sales total without any increase.
So my total should be Contract, standard with price increase and Buying, override without price increase. I used calculate columns to use "If" and "switch"function but the result is not dynamic when i change % increase.

[ΒαγγέληςΒλαχος-σφ]

i have 1 calculation group for calculation Current season and last season. But when i apply 6 different measures into a matrix i want to get side by side net revenue current and last season/side by side room nights etc. it is possible to do this thing?