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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Krcmajster
Helper IV
Helper IV

percent of grand total

hi All, 

 

I have a table with a few measures and until now it gives me what I need but I've hit a rock because of filtering.

Below the table:

 

Capture.PNG

 

Tabe is split by region. First row is a measure (named CAT Cost) that gives above numbers and that's fine. Second is the same but as % of grand total. However I need this percentage of grand total in a measure as I need it for further calculation (to multiply it with other things). How I am using it it currently also filter by region and this is not what I need

 

Is there a way to do simple measure like this

CAT COST*/sum(CAT COST) to get percentage of grand total?

                *This will still be filtered by region

 

note that there are a few filters in the measure and on the page leve which I need to keep.

1 REPLY 1
Greg_Deckler
Super User
Super User

Can you just add the measure again, use the drop down in the Fields area and choose "Show as | Percent of Grand Total"?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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