Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Sum distinct value based on another column

Hello, My table follows this structure: Dimen Level   Quantity John  XXX    15 Alice  XXX    15 Lexa  XXX    15 Vini  YYY    15 Skuerbis  YYY    15 Kim  ZZZ    5 ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Please check the below.

     

     

     

    Total Qty by distinct Level =
    VAR grouptable =
    GROUPBY (
    'Table',
    'Table'[Level ],
    "@maxqty", MAXX ( CURRENTGROUP (), 'Table'[ Quantity] )
    )
    RETURN
    SUMX ( grouptable, [@maxqty] )

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

    Linkedin: https://www.linkedin.com/in/jihwankim1975/

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Please check the below.

 

 

 

Total Qty by distinct Level =
VAR grouptable =
GROUPBY (
'Table',
'Table'[Level ],
"@maxqty", MAXX ( CURRENTGROUP (), 'Table'[ Quantity] )
)
RETURN
SUMX ( grouptable, [@maxqty] )

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/