Need Help finding a formula 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. 

Please see the file in the link.

https://www.dropbox.com/scl/fi/yl0prxe9t1k4t21tsw1m6/CPT-Volumes-Graphs-Copy.pbix?rlkey=6mk6m9kfwipp...

[lbendlin]

Your sample data shows mapping gaps (proccodes in the fact table not covered by the dimension table). Should these be ignored?