Forum Discussion

AkshayManke's avatar
AkshayManke
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 like below.

 

 

 

 

 

 

 

 

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

 

Warm Regards,

Akshay

 

Need Help
  • pankajnamekar25's avatar
    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.

2 Replies

  • pankajnamekar25's avatar
    pankajnamekar25
    Super User
    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.