Forum Discussion
DAX - Division based on multiple condition
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% |
Anonymous , based on what I got. Assume Total is column
divide(sum(Table[Total]), calculate(sum(table[Total]), allselected() ) )
1 Reply
Anonymous , based on what I got. Assume Total is column
divide(sum(Table[Total]), calculate(sum(table[Total]), allselected() ) )