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 in the userid column.

for example, I'm using this: User Reached = Sum(Single[follower_count]) + SUM(Single[following_count])

Thanks,

 

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]
    )

2 Replies

  • 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]
    )