Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous thank you for your reply. This is essentially what the tables contain. So I would for example want to select a value from column col0 (244413), which then slices the col1 (F4560, F1253), I select one of those from a new slicer. Then the selected value (e. g. F4560) get looked up in Table2[col2], and the associated value from col3 (2545) should be returned.

 

Table1

col0col1
235505F8769
232641F6453
232641F1938
232641F3275
244413F4560
244413F1253
246787F5412
232648F6023
232648F5643

 

Table2

col2col3
F45602545
F43652531
F56432552
F65392609
F12092636
F45322614
F19382437
F65782546
F54902631
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.