Forum Discussion

mrslyfox911's avatar
mrslyfox911
Advocate III
3 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    mrslyfox911 , Try a measure like

     

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

     

    or

     

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

Mahesh0016's avatar
Mahesh0016
Super User
3 years ago

Hello mrslyfox911 ,

I hope above solutions is helpful for you.

 

thank you!

Mahesh Patel

  • mrslyfox911's avatar
    mrslyfox911
    Advocate III
    3 years ago

    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