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.

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

    Anonymous thank you very much for your help , but somehow didnt work too.

     

    I have also 3 filters on this specific that i am not sure if that cause the problem.

     

    Just think we have reservations (normal and canceled). In my filters have selection on season (season 2019 , season 2020 ) , hotel name (lets say we have 2 hotels 1 and 2 ) and selection only for normal reservations ( normal = 0 , canceled = 1)

    my results