Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Have only max value in same category

Hi , I need help with this one, i have 3 column, id, category and quantity, i want have a calculate column that have only one max value and rest 0 look at screenshot:         want Output I...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous,

    You can try to use the below measure formula to get and compare with the max quantity based on category groups and use the 'if statement' to replace the not match row values to zero.

    formula =
VAR currQuantity =
    MAX ( Table[Quantity] )
VAR maxQuantity =
    CALCULATE (
        MAX ( Table[Quantity] ),
        ALLSELECTED ( Table ),
        VALUES ( Table[Category] )
    )
RETURN
    IF ( currQuantity = maxQuantity, currAmount, 0 )

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous,

You can try to use the below measure formula to get and compare with the max quantity based on category groups and use the 'if statement' to replace the not match row values to zero.

formula =
VAR currQuantity =
    MAX ( Table[Quantity] )
VAR maxQuantity =
    CALCULATE (
        MAX ( Table[Quantity] ),
        ALLSELECTED ( Table ),
        VALUES ( Table[Category] )
    )
RETURN
    IF ( currQuantity = maxQuantity, currAmount, 0 )

Regards,

Xiaoxin Sheng