Distinct sum

[mrslyfox911]

Hi,

Please help figureout how to approach measure which will return distincted summary for the column values

Example

USR_ID	TRNX	Events
100	9001	6
100	9002	6
100	9003	6
100	9004	6
102	8001	1
102	8002	1

Measure should return distinct sum of Event column grouped by USR_ID

mean expected result of measure = 6+1 = 7

[Mahesh0016]

Hello @mrslyfox911 ,

I hope above solutions is helpful for you.

thank you!

Mahesh Patel

[mrslyfox911]

Hello @Mahesh0016 
unfortunnatelly solluction not applicable for me, because I'm not looking for the summary of min and max values. target was to sum distinct value per sub category

[amitchandak · Accepted solution]

@mrslyfox911 , Try a measure like

Sumx(Distinct(Table[Events]), [Events])

or

sumx(summarize(Table, Table[User_id], Table[Events]) , [Events])

[mrslyfox911]

thank you @amitchandak 
that one working as expected

sumx(summarize(Table, Table[User_id], Table[Events]) , [Events])