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

[Anonymous]

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 to create a % change and can't seem to figure it out since I don't have 2 different columns, I have just 1 that shows 2 or 3 values based on a filter.  Any good way you have solved this?  Appreciate all the help!

	California	Michigan
120 Days	150	175
90 Days	200	235
60 Days	250	295
30 Days	300	355
14 Days	350	415
7 Days	400	475
3 Days	450	535
Event	500	595
Post Event	550	655
Total	3150	3735

[danextian]

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]

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.