cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Filter table to get rows based on distinct values in column

Hi all!

I have the following table (sample) and need a Measure to sum up the duration for  distinct IDs only i.e. (10 + 13 + 5 + 4 = 32 minutes). How do I do that?

ID           Duration (minutes)

101         10

101         10

130         13

130         13

130         13

142         5

165         4

165         4

Regards,

Yee Pin

1 ACCEPTED SOLUTION
Super User

Hi @Anonymous

Assuming duration is always the same for a specific ID:

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

3 REPLIES 3
Super User

Hi @Anonymous

Assuming duration is always the same for a specific ID:

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

Anonymous
Not applicable

@AI  Awesome! Thank you so much!!

Anonymous
Not applicable

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

Announcements