How to calculate % of subcategories taking respective Category Totals as a whole in Matrix Visual

[Anonymous]

Hi all,

Request your assistance with a measure that will help me to calculate percentage of subcategories taking respective category totals as a whole using a Matrix Visual.

Was trying to look up a similar measure which could help me achieve the same but was unable to locate a similar measure. 

Thank you in advance.

PBIX file can be downloaded from here:  https://www.dropbox.com/s/zwjlmndng6wmdns/DataFile.pbix?dl=0

-Deepak.

[FrankAT · Accepted solution]

Hi @Anonymous 

take a look at your revised and attached pbix file.

Excerpt of data with included %

[FrankAT · Accepted solution]

Hi @Anonymous 

take a look at your revised and attached pbix file.

Excerpt of data with included %

[Anonymous · Accepted solution]

Hello FrankAT,

Thank you very much for your prompt help. Now it works.

Best regards

Deepak.