Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Multi-Select Search Measure

HI All,   I have been playing out with how to figure out how to do a contains filter for two tables that I am unable to join due to the lack of data for some of the values.   In on table I have: ...
Need Help
Show and Tell
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , Anonymous 

According to your description, you want to "do a contains filter for two tables"  and thanks for your sample data.

I am not fully understand the end result you want to need, and in Table2 ,like [Project ID]=59 , it has three [Workstream ID]. What do you want to need?

And what is the field in the slicer? Can you share the end result sample data to us, like a table ?

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

So in the example above with the fake data, I would be able to select Project ID 59 and 1 from the Master Table filter and get the value of 18.

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , Anonymous 

    I still not understand your need , when we select Project ID 59 and 1 from the Master Table filter, it just return the value of 18 , like this:

     

    If this method does not meet your needs, you can provide us with  the desired output sample data in the form of tables, so that we can better help you solve the problem.

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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