Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter table to get rows based on distinct values in column

Hi all!   I had searched but do not seem to find a solution. Please help?   I have the following table (sample) and need a Measure to sum up the duration for  distinct IDs only i.e. (10 + 13 + 5 ...
Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi Anonymous 

    Assuming duration is always the same for a specific ID:

    Measure =
SUMX ( DISTINCT ( Table1[ID] ), CALCULATE ( MIN ( Table1[Duration] ) ) )

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

AI  Awesome! Thank you so much!!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

You can create a measure as below. This will work even if the values are different.

 

total =
VAR distinct_sum = SUMX( SUMMARIZE( Data, Data[ID], Data[Duration] ), Data[Duration] )
RETURN
distinct_sum