Total Measure by Group

[Anonymous]

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?

[Anonymous · Accepted 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] )
    )
)