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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
AllenVaysberg
Regular Visitor

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 @AllenVaysberg ,

 

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.










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


Proud to be a Super User!









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

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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