Forum Discussion

Sammy_voi's avatar
Sammy_voi
Frequent Visitor
3 years ago
Solved

sum total except for repeating rows

Hello community, I need a measure that sums follower_count and following_count (VALUE Column). I use some simple measures for this. However, this calculation should not calculate the repeating rows ...
Conditional Sum
sum total
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Sammy_voi 

    try like:

    Measure = 
    VAR _table =
    SUMMARIZE(
         Single,
         Single[userid],
         Single[follower_count],
         Single[following_count]
    )
    RETURN
    SUMX(
         _table, 
         Single[follower_count]+Single[following_count]
    )
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi Sammy_voi 

try like:

Measure = 
VAR _table =
SUMMARIZE(
     Single,
     Single[userid],
     Single[follower_count],
     Single[following_count]
)
RETURN
SUMX(
     _table, 
     Single[follower_count]+Single[following_count]
)
Sammy_voi's avatar
Sammy_voi
Frequent Visitor
3 years ago

Thank you FreemanZ perfectly fitted.