Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How to change Matrix subtotal aggregation to a % Change instead?

Running into a "fun" problem.  Have a report that looks like below.  The State values in Columns are based on a State column and the 2 values are based on a filter in the Matrix visual.  I am trying ...
Need Help
danextian's avatar
danextian
Super User
2 years ago

hI Anonymous ,

 

To make the calculation easier I would remove the total row and unpivot the location columns and then use this measure:

 

Percentage = 
DIVIDE (
    SUM ( 'Table'[Value] ),
    CALCULATE ( SUM ( 'Table'[Value] ), ALLSELECTED ( 'Table'[Category] ) )
)

 

Please see attached pbix for details.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks for the effort but I don't want a % of total, I need a % of change between the 2 values.  So 150 to 175 what is the % of change.