Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Total Measure by Group

Legal EntityEDIeStoreManualGrand Total
* USA43,763198,983371,231613,977
Australia7,9044,50320,71433,121
Brazil 21520,45020,665
Canada 4,39434,11638,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 EntityEDIeStoreManual
* USA7.1%32.4%60.5%
Australia23.9%13.6%62.5%
Brazil0.0%1.0%99.0%
Canada0.0%11.4%88.6%

 

What measures do I need to write to accomplish this?

Total Measure
  • Anonymous's avatar
    Anonymous
    5 years ago
    [%] =
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] )
    )
)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago
    [%] =
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] )
    )
)