Forum Discussion
Solved
Getting Sum of Unique Values
Hello All, I have a table which is having user name column which is having multiple rows with the same user. The different rows having a calculated column for sub total. I want to get something l...
Hello AkshayManke
Try this measure
Total of Unique Values =
SUMX(
SUMMARIZE(
'YourTable',
'YourTable'[User],
'YourTable'[Calculated Column]
),
'YourTable'[Calculated Column]
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hello AkshayManke
Try this measure
Total of Unique Values =
SUMX(
SUMMARIZE(
'YourTable',
'YourTable'[User],
'YourTable'[Calculated Column]
),
'YourTable'[Calculated Column]
)
Thanks,
Pankaj Namekar | LinkedIn
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.