Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
27 | |
23 | |
14 | |
11 |
User | Count |
---|---|
78 | |
63 | |
46 | |
17 | |
12 |