Forum Discussion
Distinct sum
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
mrslyfox911 , Try a measure like
Sumx(Distinct(Table[Events]), [Events])
or
sumx(summarize(Table, Table[User_id], Table[Events]) , [Events])
4 Replies
mrslyfox911 , Try a measure like
Sumx(Distinct(Table[Events]), [Events])
or
sumx(summarize(Table, Table[User_id], Table[Events]) , [Events])
thank you amitchandak
that one working as expectedsumx(summarize(Table, Table[User_id], Table[Events]) , [Events])
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
