DAX - Division based on multiple condition

[Anonymous]

Hi All,

Wanted to do a current percentage view based on condition - something like percentage over selected category.

ID	Total
A	29
B	47
C	88
B	34
C	45
A	70

Desired output is  - 

ID	Selected Category	% / Selected Category
A	A only	100%
B	A and B	45%
C	B and C	38%

[amitchandak · Accepted solution]

@Anonymous , based on what I got. Assume Total is column

divide(sum(Table[Total]), calculate(sum(table[Total]), allselected() ) )