Forum Discussion
Solved
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 1...
mrslyfox911 , Try a measure like
Sumx(Distinct(Table[Events]), [Events])
or
sumx(summarize(Table, Table[User_id], Table[Events]) , [Events])
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])
