Getting Sum of Unique Values

[AkshayManke]

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

Seem like very simple but i need help here. Thanks in advance.

Warm Regards,

Akshay

[pankajnamekar25 · Accepted solution]

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.

[AkshayManke]

Hi @pankajnamekar25, i got the expected result using the DAX. Thanks a lot for the help. !!