How to calculate below simple % in matrix chart

[Anonymous]

Hi all, 

I am using a matrix chart , where I want to show the % of each category  like below :

for MUID 500167, there are 3-categories and frequency of each is mentioned.  here Category 'General Medicine' have F=2, so % is 2/4*100 ie 50%, later for 'Infection Diease' F =1 , so % =1/4*100 ie 25% ,so on.

can someone help me?

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

Create a measure as below:

Measure = 
var _counttotal=CALCULATE(SUM('Table'[M_Frequency]),FILTER(ALL('Table'),'Table'[MUID]=MAX('Table'[MUID])))
Return
IF(ISINSCOPE('Table'[Category]),DIVIDE(MAX('Table'[M_Frequency]),_counttotal),BLANK())

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , This seem like % of the subtotal

You need to use all except

Assume you are using Cat under MUID (rows of matrix)

Try a new measure like

% of subtotal = divide([M_frequency], calculate([M_frequency] , allexcept(Table, Table[Cat])))

refer :https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

[PaulDBrown]

@Anonymous 

can you share a sample dataset or even better a PBIX file?

by the looks of it, you need an inital measure which would be:

frequency of selected categories =
CALCULATE( [Sum of Frequencies], ALLSELECTED (Table[Category]))

followed by the final measure::

% of selected categories = DIVIDE( [Sum of Frequencies], [frequency of selected categories])

[Greg_Deckler]

@PaulDBrown - Tested your solution Paul, worked like a charm.