Forum Discussion

Rohini0606's avatar
Rohini0606
New Member
2 years ago

Filtering a column with multple values in asingle row using a single value

I have 2 column with multiple values in a single row. I have another column with values extracted from these two columns. I need to filter these multi value columns using a single value from the newly created column. Is that possible?

Need Help
Tips and Tricks

2 Replies

  • danextian's avatar
    danextian
    Super User
    2 years ago

    Hi Rohini0606 ,

    The solution depends on whether you kept the original column with multiple values  prior to it being split into rows of single values.  If you've setup your tables this way, you can create a many to many relationship between the two tables:

     

     

    If you did not, you can create a measure to filter the  column with multiple values by:

    filter measure = 
CALCULATE (
    COUNTROWS ( filter2 ),
    FILTER (
        filter2,
        CONTAINSSTRING ( SELECTEDVALUE ( 'Table'[multiple] ), filter2[Single] )
    )
)

    Please see attached pbix for your reference.

    • Rohini0606's avatar
      Rohini0606
      New Member
      2 years ago

      Hi, 

       

      Thank you for the quick reply. I was able to resolve the issue. I had to change relationship type (one to many) between the tables. 

      Here is the screenshot of my requirement:

      once again thanks for your help.

       

      Regards,

      Rohini