Calculating % per category of total

[Anonymous]

Hi all,

I have been searching and tried quite a few things but I cannot get this to work. I am trying to figure out how I can make calculation where I can have a value of a filtered row showing as a % of a total. My data looks like this:

Customer	Value	OK/NOT
A	100	OK
A	100	NOT
B	200	NOT
B	200	NOT
C	300	OK
C	300	OK

I would need to summarize this per client, showing "How many % does Client X NOT's consist of based on the total value of NOTs". So it should look like this:

Customer	Total value	Total value of NOT	% NOT of the total value of NOT
A	200	100	20%
B	400	400	80%
C	600	0	0%
Total	1200	500	100%

It's mainly the last column I cannot manage to get into a matrix, because everytime I try it will just divide it on customer level, not based on the total SUM of "Total value of NOT". 

Thanks in advance. 

[amitchandak · Accepted solution]

@Anonymous ,

Measure for 3rd column

divide(calculate(sum(Table[Value]), filter(Table, Table[OK/NOT] = "NOT")),calculate(sum(Table[Value])))

Measure for 4th  column

divide(calculate(sum(Table[Value]), filter(Table, Table[OK/NOT] = "NOT")),calculate(sum(Table[Value]), filter(allselected(Table), Table[OK/NOT] = "NOT")))

[Anonymous]

Thank you, works great!