Forum Discussion

lherbert501's avatar
lherbert501
Post Prodigy
2 years ago
Solved

Calculation Groups - Difference measures

Hi,   Could somebody please help me whether this is possible?   I need the layout like below to be in a matrix. I've used a calculation group for current and previous period and this works well b...
Need Help
lherbert501's avatar
lherbert501
Post Prodigy
2 years ago

Hi Daniel29195 ,

 

Apologies I'm a little confused. When you say table with levels, do this mean with calculation groups?

 

Thanks again

 

Liam

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

lherbert501 

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 . 

 

 

 

  • lherbert501's avatar
    lherbert501
    Post Prodigy
    2 years ago

     Thanks Daniel29195 . And this would still come out grouped like below?

     

    • Daniel29195's avatar
      Daniel29195
      Community Champion
      2 years ago

      lherbert501 

      yes sure.

      if you can, share some sample data, and i will do it for you . 

      • lherbert501's avatar
        lherbert501
        Post Prodigy
        2 years ago

        Hi Daniel29195 

         

        Thank you so much.  

         

        I hope that's okay what I've attached. I've used shapes to show what I require on the page

         

        Sample Data.pbix

  • lherbert501's avatar
    lherbert501
    Post Prodigy
    2 years ago

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