Forum Discussion

ThisIsVS's avatar
ThisIsVS
Frequent Visitor
4 years ago
Solved

Calculate Custom Maximum Value Column

This might be easy. Let's say I've the following Pivot Table. What would be the dax expression to create a measure named "Max" so that i would get the following.       i.e If Value ...
DAX
  • tamerj1's avatar
    tamerj1
    4 years ago

    ThisIsVS 

    You may also try

    Amount Max =
VAR MaxAmount =
    MAXX ( ALLSELECTED ( TableName[Year] ), [Sum of Sales Amount] )
RETURN
    IF ( [Sum of Sales Amount] = MaxAmount, MaxAmount )
tamerj1's avatar
tamerj1
Community Champion
4 years ago

ThisIsVS 

Please try

Amount Max =
CALCULATE (
    MAXX ( ALLSELECTED ( TableName[Year] ), [Sum of Sales Amount] ),
    KEEPFILTERS ( TableName[Year] )
)
tamerj1's avatar
tamerj1
Community Champion
4 years ago

ThisIsVS 

You may also try

Amount Max =
VAR MaxAmount =
    MAXX ( ALLSELECTED ( TableName[Year] ), [Sum of Sales Amount] )
RETURN
    IF ( [Sum of Sales Amount] = MaxAmount, MaxAmount )
  • ThisIsVS's avatar
    ThisIsVS
    Frequent Visitor
    4 years ago

    It worked. Thankyou, Sir. 🙂