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

[Anonymous]

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 · Accepted solution]

Hi @Anonymous 

please use

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