topic Re: Need Help finding a solution for percentage of totals in DAX Commands and Tips

Need Help finding a solution for percentage of totals

Anonymous — Thu, 20 Jun 2024 21:55:15 GMT

I need to find the percentage of each providers total units per Proccode for 2024.

For Example: if Dr Doe had 1 unit for proccode 9921 and 3 units for 9922.

it would be 25% for 99202 and 75% for 99203.

How can I get my table to display this? I tried using "show value as" bt it only shows the percentage of the grand total. When I am needing the percentage of each indiviual providers total.

Re: Need Help finding a solution for percentage of totals

vicky_ — Thu, 20 Jun 2024 22:33:35 GMT

I have my table setup like the above, and then created a measure:

Percentage of Total per Provider = var denominator = CALCULATE(COUNTROWS('Table'), REMOVEFILTERS('Table'[Postcode])) var numerator = COUNTROWS('Table') return DIVIDE(numerator, denominator)

And then the result looks something like:

If that isn't what you want, please provide some sample data with any sensitive info removed so that we can provide more specific help.

Re: Need Help finding a solution for percentage of totals

Anonymous — Mon, 24 Jun 2024 13:40:45 GMT

Here some sample data. I have thousands of rows of data so I am not able to recreate the table you have.

https://www.dropbox.com/scl/fi/yl0prxe9t1k4t21tsw1m6/CPT-Volumes-Graphs-Copy.pbix?rlkey=6mk6m9kfwipptw2am2ucleevl&st=j2y0swk9&dl=0