Solved: Dax - Creating a measure which return MAX Value of...

Anonymous · ‎07-26-2022

Hi All,

I have 2 fields - Cluster (Dİmension) And Sold(Measure)

I want to create a measure that returns the maximum value of the sold field by cluster. in the below case it should return 7263

Could you help, please?

Thanks all!

tamerj1 · ‎07-26-2022

Hi @Anonymous

please use

Max Sold =
MAXX ( ADDCOLUMNS ( VALUES ( TableName[Cluster] ), "@Sold", [Sold] ), [@Sold] )

tamerj1 · ‎07-26-2022

Hi @Anonymous

please use

Max Sold =
MAXX ( ADDCOLUMNS ( VALUES ( TableName[Cluster] ), "@Sold", [Sold] ), [@Sold] )

Dax - Creating a measure which return MAX Value of the Categories