Forum Discussion
Using SELECTEDVALUE() for lookup in different table
Hi Community! I have a question regarding the usage of the SELECTEDVALUE() function. I have created a measure Date as in the picture below: Table1 contains a column, col1, that has around ...
Hi Anonymous ,
The Table data is shown below:
Use the following DAX expression to create a measure
SELECTEDVALUE function - DAX | Microsoft Learn
LOOKUPVALUE function (DAX) - DAX | Microsoft Learn
Measure = VAR _col1ForSlicer = SELECTEDVALUE(Table1[col1]) RETURN LOOKUPVALUE(Table2[col3],Table2[col2],_col1ForSlicer)Final output
If the problem persists, could you please share your .pbix file without sensitive data?
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I saw you shared your .pbix file, but your reply has been deleted. If your problem has been solved, please mark my answer as the solution, thank you.
Best Regards,
Wenbin Zhou