Summarize table with sum duplicates

[rmeng]

I have a table with a number field (NUMBER_OF_PARTICPANTS) that is duplicated for each EVENTID ( in this case EventID 86 and 99).

1. I need a measure to sum the unique value of each Event ID. 

[ERD · Accepted solution]

@rmeng , one of the ways is to use the next measure:

measureName =
VAR _t = SUMMARIZE ( T, T[event_id], T[num_part] ) 
RETURN 
SUMX ( _t, [num_part] )

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.

[BeaBF]

@rmeng  Hi!

Could you paste the starting data table as a comment and an example output that you would expect?

Thx,

B.