Forum Discussion

siuchan's avatar
siuchan
Frequent Visitor
8 years ago
Solved

Percentage Sum Total

I would like to write a new measure to calculate the % of the total for the period. I can calculate the sum score for the whole table, but not by the period. Thanks,      Company    Period   Score ...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    siuchan,

     

    You may try using ALLSELECTED Function.

    Measure =
DIVIDE (
    SUM ( Table1[Score] ),
    CALCULATE ( SUM ( Table1[Score] ), ALLSELECTED ( Table1[Company] ) )
)
Vvelarde's avatar
Vvelarde
Community Champion
8 years ago

siuchan

 

Hi, try with this measure

 

% Total for Period =
VAR TotalPeriod =
    CALCULATE ( SUM ( Table1[ Score ] ), ALLEXCEPT ( Table1, Table1[  Period ] ) )
RETURN
    DIVIDE ( SUM ( Table1[ Score ] ), TotalPeriod )

Regards

 

Victor

 

siuchan's avatar
siuchan
Frequent Visitor
8 years ago

Thanks for your suggestion. I tried it. But, it gave me the sum of the whole table. only If i specific the time period with the slider, they i can get the total sum % at the specific period.