Forum Discussion

Helper II

1 year ago

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...

Need Help

pankajnamekar25
1 year ago
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.