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

  1. 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.

2 Replies

  • 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.

  • BeaBF's avatar
    BeaBF
    Icon for Super User rankSuper User
    4 years ago

    rmeng  Hi!

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

     

    Thx,

    B.