Forum Discussion
Caclulation Group Based on Another Calculation Group
Hello!
I have a report in which I have a few simple metrics like SUM(Sales), Sum(Total), Sum(Tax), etc. I have also created a relative time calculation group that allows for further filtering based on relative time scenarios like MTD This Year, MTD Last Year, MTD YOY % (see screenshot).
This works great and I can now do two things: 1) I can use a slicer with the relative time group so that I can select "MTD LY" and get the corresponding value, and 2) I can further create additional measures defined like
Total MTD LY = CALCULATE('~ Measures'[Total],FILTER('Relative Time','Relative Time'[Relative Time]="MTD LY")).
What I am wondering is if there is an elegant way using calculation groups to split the MTD, QTD, YTD from the TY, LY, YOY% so that I can use the same base metric in all my visualizations and apply two filters to get the desired result?
Thanks!
1 Reply
dggauthier , I have covered similar example here
see if this can help
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
