Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I've been stuck working on creating another column in my matrix chart to capture the total percentages (shown in the red). Does anyone have any suggestions on how to solve for this or where to begin with the DAX formula? Thank you in advance for your help!
Status | Group 1 | Group 2 | Total | Open/Closed % |
Closed | 75 | 35 | 110 | 73.33 % |
Open | 25 | 15 | 40 | 26.67% |
Total | 100 | 50 | 150 | 100 % |
hi @Linders ,
not sure if i fully get you, supposing you have a data table like:
Status | Group | Value |
Open | Group1 | 25 |
Open | Group2 | 15 |
Closed | Group1 | 70 |
Closed | Group1 | 5 |
Closed | Group2 | 35 |
try to plot a Matrix visual with two measures like:
ValueSum = SUM(data[Value])
Open/Closed% =
VAR _all = CALCULATE([ValueSum], ALL(data[status]))
VAR _result = DIVIDE([ValueSum], _all)
RETURN _result
it worked like:
User | Count |
---|---|
50 | |
25 | |
18 | |
17 | |
14 |
User | Count |
---|---|
91 | |
86 | |
39 | |
25 | |
21 |