Assign the value in Column 2 to a measure based on the value of Column 1.

[xandurr]

I have a table with 2 columns.

How can i assign the value in Column 2 to a measure based on the value of Column 1.

AKA, what is the DAX equivalent of the below SQL code

SELECT column2

FROM table

WHERE column1 = 'ThisValue'

[v-sihou-msft]

@xandurr

You may create a measure like below; 

Measure =
IF ( MAX ( Table[Column1] ) = "ThisValue", MAX ( Table[Column2] ), BLANK () )

Regards,

[xandurr]

Sadly that does not work as the value is not the max value.

And it then selects the incorrect value in the script