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.
Legal Entity | EDI | eStore | Manual | Grand Total |
* USA | 43,763 | 198,983 | 371,231 | 613,977 |
Australia | 7,904 | 4,503 | 20,714 | 33,121 |
Brazil | 215 | 20,450 | 20,665 | |
Canada | 4,394 | 34,116 | 38,510 |
I have a matrix visual like this in Power BI. The Grand Total for the rows calculates and displays, but I think I need a measure to calculate the row total in order to derive the percent of total in each row by Order Category (EDI, eStore, Manual).
In the end, the matrix will look like this:
Legal Entity | EDI | eStore | Manual |
* USA | 7.1% | 32.4% | 60.5% |
Australia | 23.9% | 13.6% | 62.5% |
Brazil | 0.0% | 1.0% | 99.0% |
Canada | 0.0% | 11.4% | 88.6% |
What measures do I need to write to accomplish this?
Solved! Go to Solution.
[%] =
DIVIDE(
[Total],
CALCULATE(
[Total],
ALLSELECTED( T[Order Category] )
)
)
... if you want to get visual percentages...
and this if you want to get absolute percentages:
[%] =
DIVIDE(
[Total],
CALCULATE(
[Total],
ALL( T[Order Category] )
)
)
[%] =
DIVIDE(
[Total],
CALCULATE(
[Total],
ALLSELECTED( T[Order Category] )
)
)
... if you want to get visual percentages...
and this if you want to get absolute percentages:
[%] =
DIVIDE(
[Total],
CALCULATE(
[Total],
ALL( T[Order Category] )
)
)
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |