The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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] )
)
)
User | Count |
---|---|
11 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
14 | |
14 | |
9 | |
7 |