Forum Discussion
Calculation Groups - Difference measures
output
link to file :
https://drive.google.com/file/d/1ZGTRZGdnUbNmPqFTGsyRbRJ6rv1aJgMq/view?usp=sharing
let me know if this works for you .
If this answers your question , mark it as the solution ā so can you can help other people in the community find it easily .
maybe you can do the following :
create a table with the following structure :
level 1 level2
growth total sales
growth total margin
growth calculation 3
growth calculation 4
previous period total sales
previous period total margin
current period total sales
current period total margin
then in your calculation you can use one measure with switch statement
Hi Daniel29195 ,
Apologies I'm a little confused. When you say table with levels, do this mean with calculation groups?
Thanks again
Liam
table using enter data manually .
this way you are creating the structure of your table how you want it to be .
and then you play with the measure and switch to change the calculation behavior base on the column you are in .
The best I've managed is to get both measures to display as blank in a matrix by using this in tabular editor
IF( SELECTEDMEASURENAME() in {"Cost1", "Cost2"}, BLANK(), SELECTEDMEASURE() - CALCULATE(SELECTEDMEASURE(), SAMEPERIODLASTYEAR(DimDate[DateFull])) )