topic Re: Calculate Custom Maximum Value Column in DAX Commands and Tips

Calculate Custom Maximum Value Column

ThisIsVS — Sat, 20 Aug 2022 14:42:29 GMT

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 in "Sum of Sales Amount" column equals Maximum Value of "Sum of Sales Amount" column, then the value itself, otherwise a blank.

Re: Calculate Custom Maximum Value Column

tamerj1 — Sat, 20 Aug 2022 14:42:45 GMT

Hi ThisIsVS

is the Year column from the same table or a date table?

Re: Calculate Custom Maximum Value Column

ThisIsVS — Sat, 20 Aug 2022 14:43:49 GMT

Same table, Sir.

Re: Calculate Custom Maximum Value Column

tamerj1 — Sat, 20 Aug 2022 14:49:39 GMT

ThisIsVS

Please try

Amount Max = CALCULATE ( MAXX ( ALLSELECTED ( TableName[Year] ), [Sum of Sales Amount] ), KEEPFILTERS ( TableName[Year] ) )

Re: Calculate Custom Maximum Value Column

tamerj1 — Sat, 20 Aug 2022 14:55:31 GMT

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 )

Re: Calculate Custom Maximum Value Column

ThisIsVS — Sat, 20 Aug 2022 15:05:39 GMT

It worked. Thankyou, Sir. 🙂