Measure to get value from row and column names

[Anonymous]

Hi,

This seems like it should be really easy, alas I am a new user of DAX. I have a table and I would like a measure to retrieve a value given the column and row names. I have a measure that uses "FILTER", but I need something that also filters for the "Min" column regardless of the value in the table. I am not trying to calculate anything, I am quite simply trying to query for a value given the column and row names.

The measure looks like this:

Pressure_Min = FILTER(SensorTable, [Sensor] = "Pressure" && {add something to filter for column = [Min]})

This measure would grab the value 5 to use as a limit value for a gauge visual. Thanks for the help.

Sensor	Min	Max
Pressure	3	5
Temperature	80	100

[CNENFRNL · Accepted solution]

You can't reference a column with a string variable in DAX; transform the dataset,