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.
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
Solved! Go to Solution.
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
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.
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
@JayTG123 , Try like
divide([measure], calculate([measure],all(Table[Organization]) ) )
or
divide([measure], calculate([measure],removefilters(Table[Organization]) ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |