Link to blog post and dataset: businessintelligist.com/2021/09/27/what-to-do-when-calculation-groups-break-your-measures-powerbi-tutorial/
Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main reason behind is some sort of invalid DAX in your calculation group. However, sometimes this might happen even if on a surface it appears that your DAX is perfectly fine.
The scenario that I cover in this video deals with a situation when you have added a calculation item that is expecting a number (for example you are trying to calculate a Year Over Year variance, or something like that). Or in my example I have create an even simpler one that takes the existing value of the measure and then increments it by one.
Turns out that although the DAX is very simple, if you have measures that return text values (and we often do as we need to display dynamic titles, etc.) then those measures become broken and the only way for fix them is to add a bit of code to your DAX statement to make a bit more robust as well is to introduce a naming convention to your measures so you can recognize which measures are text and which ones are not simply by looking at their name.
What I often do is either prefix or suffix the text measure name with something like “TEXT”, “Label”, “Lbl”, etc. then you can modify your DAX to follow the logic as outlined in this video.
- What to DO When Calculation Groups Break Your Measures ( Download)
- How to Reduce # of Measures w/ Calculation Groups in Power BI ( Download)
- Reduce the Amount of Measures You Write w/ DAX Calculation Groups | Power BI DAX Tutorial ( Download)
- Select a Measure 👆 using a Slicer ✔️ and Calculation Groups ( Download)
- Fix my Calculation Group in Power BI ( Download)
- Calculation Groups & DAX Slicer ( Download)
- Power Break with Bernat Agulló - Introduction to calculation Groups in Power BI ( Download)
- Getting Started with Calculation Groups in Power BI ( Download)
- Calculation groups debut in Power BI Desktop ( Download)
- Calculation Groups Pitfall and how to escape - Power BI ( Download)
- How Calculation Groups can enhance custom ToolTips - Power BI ( Download)
- Exploring the NEW Semantic Model View + Native Calculation Groups! ( Download)
- Dynamic Measure Calculation Group as Custom Action ( Download)
- Power BI Table | How to keep the calculation group in 1st column when adding additional dimensions ( Download)
- Power BI Desktop: Calculation Groups are IN, but there is a MAJOR BUG :( ( Download)
