Calculation Groups

[Manesh_13]

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 (Current, PY, var Prior Year and % var prior year).
this is what it is currently giving me:

however I want it to display all the sales for Current, PY, var PY and % var PY together and then sentty and then orderqty does anyone know if that can be done and if so how can it be done? 

Thanks 

Manesh 

[Syndicate_Admin]

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"))

[v-zhangtin-msft]

Hi, @Manesh_13 

Can you provide some sample data? And the output you expect. It can be displayed as a picture or in Excel.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Manesh_13]

Hi, 

This is how I want it to look like:

so that each metric is grouped together with its respective Current, PY, var to PY, %Var to PY values.