% Of revenue per outlet

[YuliyaMusiyuk]

Hello,

i am trying to calculate % of revenue per outlet; see below - i need each Cat-Category to be devided by Total rev in that Cat-DepartmentDesc

[v-eqin-msft · Accepted solution]

Hi @YuliyaMusiyuk ,

Please try the following formula :

div by rev =
VAR _rev =
    CALCULATE ( SUM ( 'Table'[REV] ), ALLEXCEPT ( 'Table', 'Table'[Cat-Depart] ) )
VAR _mtd =
    CALCULATE (
        SUM ( 'Table'[CY MTD] ),
        FILTER (
            'Table',
            'Table'[Cat-Depart] = MAX ( 'Table'[Cat-Depart] )
                && 'Table'[Cat-Category] = MAX ( 'Table'[Cat-Category] )
        )
    )
RETURN
    DIVIDE ( _mtd, _rev )

Then format the measure as 2 decimal places. The final output is shown below:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@YuliyaMusiyuk 

could you pls provide some sample data?  I am confused about your description and screenshot.