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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JayTG123
Advocate I
Advocate I

Filtered % value over total value.

 

Hi all,

Probably very simple but I am stuck in finding the correct DAX Forumla to get the percentage of "Total Permits" per Organisation, over the overall total. This is to see which Organisation is the busiest by percentage. % - The table below, the Organisations have been filtered.

Jay

 

JayTG123_0-1643629208309.png

 

1 ACCEPTED SOLUTION
MargaritaG
Resolver I
Resolver I

Hey, 
Total Permits is probably a measure here e.g. SUM([Total Permits]) or some similar function to count permits- thus would rename # Permits. 
Try to create a new measure # Total Permits 
Calculate ( SUM([Total Permits]), ALL([Organisation]))
Then % measure would be just  DIVIDE (# Permits , # Total Permits)

Let me know if this is what you are looking for

View solution in original post

6 REPLIES 6
JirkaZ
Solution Specialist
Solution Specialist

If it's the Matrix visual you are using then the easies way would be to drop the "Total Permits" to the table again and in the "Values" pane switch it to "Show Value As" --> "Percent of grand total"

Hi @JirkaZ I would normally use this but not all Organisations are listed on the table - so its not an accurate percentage for the overall permits / all organisations. 

JirkaZ
Solution Specialist
Solution Specialist

What @MargaritaG  says then if it's really all the orgs.

MargaritaG
Resolver I
Resolver I

Hey, 
Total Permits is probably a measure here e.g. SUM([Total Permits]) or some similar function to count permits- thus would rename # Permits. 
Try to create a new measure # Total Permits 
Calculate ( SUM([Total Permits]), ALL([Organisation]))
Then % measure would be just  DIVIDE (# Permits , # Total Permits)

Let me know if this is what you are looking for

Perfect !! Thank you so much @MargaritaG !!

Jay

amitchandak
Super User
Super User

@JayTG123 , Try like

 

divide([measure], calculate([measure],all(Table[Organization]) ) )

 

or

 

divide([measure], calculate([measure],removefilters(Table[Organization]) ) )

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors