topic Re: sum total except for repeating rows in DAX Commands and Tips

sum total except for repeating rows

Sammy_voi — Fri, 20 Jan 2023 21:42:02 GMT

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,

Re: sum total except for repeating rows

FreemanZ — Fri, 20 Jan 2023 21:58:42 GMT

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]

)

Re: sum total except for repeating rows

Sammy_voi — Fri, 20 Jan 2023 22:05:18 GMT

Thank you FreemanZ perfectly fitted.