Lookup to find similar value

[Anand09]

Hi Friends, 

I am working upon below task . Id value appears in both plans ex DEF started in 2406 and completed in 2409. requirement is any user selects either 2406,2409 its should pass those selected filter to post plan column and return Yes for matched and no for non matched. can you guys help me in dax to acheive.

[shafiz_p · Accepted solution]

Hi @Anand09  Considering the below scenario you want :

If this is the case, you can try below code:

Found or Not = 
VAR searchvalue =
    SELECTEDVALUE (PlanTable[Plan])
RETURN
IF(
    HASONEVALUE(PostPlan[Post Plan]),
    IF (
        CONTAINSSTRING (
            CONCATENATEX ( 'PostPlan', 'PostPlan'[Post Plan], "," ),
            searchvalue
        ),
        "Yes",
        "No"
    )
)

Here, PlanTable is a seperate table contains all the unique plan. Plan column from this table will be used in slicer for user selection.

You can use, your column name which contains all unique plan will be used in slicer.

Hope this helps!!

If this solved your problem, please accept it as a solution.

Best Regards,
Shahariar Hafiz

[parry2k]

@Anand09 maybe add a measure like this, change table and column name as per your model:

Selected Plan = 
VAR __selectedPlan = SELECTEDVALUE ( UserSelection[Plan] )
VAR __postPlan = SELECTEDVALUE ( Plan[Post Plan] )
RETURN
IF ( CONTAINSSTRING ( __postPlan, __selectedPlan ), "Yes", "No" )