Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Incorrect row total

Nice day Someone can advise me, I have problems calculating the total number of rows, at other times use measures such as Hasonevalue, isinscope, filter, among others for the column total, however...
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, Syndicate_Admin 

    Please add a new measure to replace 'falls':

    New falls =
IF (
    ISINSCOPE ( 'WeeksOneContact'[Week OC] ),
    [Falls],
    SUMX ( ALLSELECTED ( 'WeeksOneContact'[Week OC] ), [Falls] )
)

    Best Regards,
    Community Support Team _ Eason

     

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

I share an example image, as can be seen after comparing a week vs the previous one, a result of 6 and 7 is obtained so the sum is expected with a total of 13, however when evaluating at the row level, the measure returns 0 in the total of the column

v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, Syndicate_Admin 

Please add a new measure to replace 'falls':

New falls =
IF (
    ISINSCOPE ( 'WeeksOneContact'[Week OC] ),
    [Falls],
    SUMX ( ALLSELECTED ( 'WeeksOneContact'[Week OC] ), [Falls] )
)

Best Regards,
Community Support Team _ Eason