Forum Discussion

rmeng's avatar
rmeng
Icon for Helper II rankHelper II
4 years ago
Solved

Summarize table with sum duplicates

I have a table with a number field (NUMBER_OF_PARTICPANTS) that is duplicated for each EVENTID ( in this case EventID 86 and 99). I need a measure to sum the unique value of each Event ID.    ...
Help required
  • ERD's avatar
    ERD
    4 years ago

    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.

ERD's avatar
ERD
Icon for Community Champion rankCommunity Champion
4 years ago

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.