Forum Discussion

Manesh_13's avatar
Manesh_13
Frequent Visitor
2 years ago

Calculation Groups

Greetings All,    I am having an issue at the moment with the display I am getting with calculated groups I want the display to group the output by the measure rather than the Date functions (Curre...
Need Help
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Hi, you cannot get the view you would like directly, however you can create new single measures using your calc group within the filter of a calculate, this will allow you to drop your measures where you like.

E.g..

- CALCULATE([Sell], FILTER(ALL('CalcGroup'), 'CalcGroup'[TimeAnalysis] = "Current"))

- CALCULATE([Sell], FILTER(ALL('CalcGroup'), 'CalcGroup'[TimeAnalysis] = "PY"))

- CALCULATE([Sell], FILTER(ALL('CalcGroup'), 'CalcGroup'[TimeAnalysis] = "Var Prior Year"))