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 example Window from First table and show table with row contains Window from Second table (Black windows, White window)

Thank you

 

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.

2 Replies

  • 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.