Forum Discussion
Helper IIIConditional Formatting Calculation Groups
Hi watje255_ju
It would have worked but that isn't how you're supposed to create a calcuation item. An item would be something like
CALCULATE ( SELECTEDMEASURE (), SAMEPERIODLASTYEAR ( Dates[Date] ) )SELECTEDMEASURE stands for whatever measure that you'd want SAMEPERIODLASTYEAR to be applied to in the context of the calculation group. You can see in the first screenshot of my initital reply how your setup behaves. In one of his videos, the author actually discussed how to create a calculation item
Super UserHi watje255_ju ,
This isn't how a calculation group is supposed to be used. Whatever you put in the matrix, you'll get the same value for sales, budget and var regardless of the calcution group item if you use like as if you're creating a regular measure. It is supposed to be used in applying repetitive calculations over different measures like YTD, previous year, etc (imagine doing that to 50 measures). So if you put sales in a calculation column, it will apply YTD and previous year calculations on top of the sales measure. The same calculation will be applied if a different measure is used.
With your conditional formatting formula, it doesn't really return blank if the calculation item is Budget as shown on the screenshot below.
Instead, you can try a different approach by using a disconnected table and switching measure formula. Please see the attached pbix.