Forum Discussion

BJM1's avatar
BJM1
Regular Visitor
5 years ago

Conditionals with multiple matches

Apologies in advance - I am just starting out using Power BI.   In my dataset, I have a column that contains tags to categorize my data in different ways.  I am using a conditional column to pull o...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi BJM1 ,

 

Since you want a dynamic output based on a slicer, I suggest you create measure instead.

Measure = IF( CONTAINSSTRING(MAX('Table'[Tag]),SELECTEDVALUE('Citrus Fruit'[Citrus Fruit])),1,0)

Then apply it to filter pane, set as "=1" like this:

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

  • BJM1's avatar
    BJM1
    Regular Visitor
    5 years ago

    Hello Anonymous ,

    Your suggestion is very helpful.  Could you suggest a query/function to cleanse the values out of the Tags column so that only the values assigned in table Citrus Fruit remain?  I'm hoping for some solution that is based on the values I want to keep because I don't control the values that are added as tags.  I would like to only display the ones that match the Citrus Fruit listing.  

     

    Thanks!