Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

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 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!

 

 CaliforniaMichigan
120 Days150175
90 Days200235
60 Days250295
30 Days300355
14 Days350415
7 Days400475
3 Days450535
Event500595
Post Event550655
Total31503735

 

2 REPLIES 2
danextian
Super User
Super User

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

 

danextian_0-1696220488427.png

Please see attached pbix for details.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Anonymous
Not applicable

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.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.