Caclulation Group Based on Another Calculation Group

[dggauthier]

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!

[amitchandak]

@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