Forum Discussion
Solved
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 Organisati...
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
