Need Help finding a solution for percentage of totals

[Anonymous]

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. 

[vicky_]

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.

[Anonymous]

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=6mk6m9kfwipp...