Forum Discussion

SpiroswayGR's avatar
SpiroswayGR
Icon for Resolver III rankResolver III
5 years ago

Column Total but 100%

Dear community,   Do you have any solution how can we show column total but should be on % of 100%.   I have this solution :    but i would like to change it like this , so total of subca...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi SpiroswayGR ,

 

Please try this:

Measure =
VAR _per =
    CALCULATE ( SUM ( 'Table'[Revenue] ), ALLEXCEPT ( 'Table', 'Table'[Category] ) )
RETURN
    IF (
        HASONEVALUE ( 'Table'[Sub] ),
        DIVIDE ( MAX ( 'Table'[Revenue] ), _per ),
        _per
    )

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.