sum total except for repeating rows

[Sammy_voi]

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,

[FreemanZ · Accepted solution]

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]

Thank you @FreemanZ perfectly fitted.