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 + 4 = 32 minutes). How do I do that?
ID Duration (minutes)
Thanks in advance!
Go to Solution.
Assuming duration is always the same for a specific ID:
SUMX ( DISTINCT ( Table1[ID] ), CALCULATE ( MIN ( Table1[Duration] ) ) )
View solution in original post
@AI Awesome! Thank you so much!!
You can create a measure as below. This will work even if the values are different.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!