Forum Discussion

jirikopriva's avatar
jirikopriva
Frequent Visitor
3 years ago
Solved

Get rows from another values based on SELECTEDVALUE

Hi,  i want please help with this case in DAX. I have two tables without relantionship. First table contains words for select, second table contains product name: I want selectvalue for exam...
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, jirikopriva 

     

    You can try the following methods.
    Measure:

    Measure =
VAR _search =
    SEARCH (
        SELECTEDVALUE ( 'First table'[First table] ),
        SELECTEDVALUE ( 'Second table'[Second table] ),
        1,
        BLANK ()
    )
RETURN
    IF ( _search <> BLANK (), 1, 0 )

    Put Measure in the Filter of the second table view and set it to equal 1.

    Result:

    Is this the result you expect?

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, jirikopriva 

 

You can try the following methods.
Measure:

Measure =
VAR _search =
    SEARCH (
        SELECTEDVALUE ( 'First table'[First table] ),
        SELECTEDVALUE ( 'Second table'[Second table] ),
        1,
        BLANK ()
    )
RETURN
    IF ( _search <> BLANK (), 1, 0 )

Put Measure in the Filter of the second table view and set it to equal 1.

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.