Dynamic LOOKUPVALUE

[addd123]

Im trying to look up a specfic value in a table. Which i then want to implement in a chart. 

The trick is i want this look up to be dynamic according to a slicer/selection in the report. 

My first idea was the LOOKUPVALUE function. Is there a way to adjust the <result_columnName> and the <search_columName> according to a selection in a slicer?

LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>[, <search_columnName>, <search_value>]…)

Thanks!

[v-qiuyu-msft · Accepted solution]

Hi @addd123,

Firstly, I would suggest you take a look at this article to know how use LookupValue() function: LOOKUPVALUE Function (DAX). From the article, we can know that both result_columnName and search_columnName parameters cannot be an expression. It means that we are not able to search dynamic column and return dynamic column matched value.

In your scenario, if you want to lookup different columns use one LookupValue() expression, I'm afraid it can't be achieved currently. You need to specify many expressions to search separate column and return matched value for a specified column.

But if you want to filter data returned from the LookupValue() function based on checked value from the slicer, you can create a LookupValue() expression, and drag related field to slicer, value returned by LookupValue() function can be filtered dynamically. See:

AlltheDatasummary

You can take a look at attached .PBIX file.

If you have any question, please feel free to ask.

Best Regards,
Qiuyun Yu