DAX help

[marcoproserpio]

Goodmorning,
I would like to develope a measure that returns the value of a specific column (i.e. [model]) for the maximum value of another measure (e.g. total sales).

The output of the measure should be "C" in this case.

Thank you.

[Jihwan_Kim]

Hi, @marcoproserpio 

Please check the below.

Result Measure =
CALCULATE (
MAX ( 'Table'[Model] ),
FILTER (
ALL ( 'Table' ),
SUM ( 'Table'[Calculated] ) = MAX ( 'Table'[Calculated] )
)
)

https://www.dropbox.com/s/1jm8bjuxuljjazu/marcoproserpio.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[amitchandak · Accepted solution]

@marcoproserpio , depending on what calculate is

if this a column
lastnonblankvalue(Table[calculate), MAx(Table[Model]))

if this is a measure
measure =
var _max = maxx(allselected(Table), [calculated])
return
maxx(filter(Values(Table[model]), [calculated] =_max),[Model])