Filtering Power BI Visuals by Tags

[Kenzaobd99]

I'm trying to filter my Power BI visuals based on specific tags from words table Tags1.pbix. 

Here's the SQL query I'm working with:

SELECT title from meta m

left JOIN keywords k on m.id = k.id

left join words w on k.word = w.[index-tag] where tag = N'News'

INTERSECT

SELECT title from meta m

left JOIN keywords k on m.id = k.id

left join words w on k.word = w.[index-tag] where tag = N'Palestine'

I want to replicate this filtering behavior in Power BI visuals. I've tried using filters, but I can't seem to get it to work properly

Any suggestions on how to achieve this in Power BI? 

[Ashish_Mathur]

Hi,

Share some data to work with, explain the question and show the expected result.  Share data in a format that can be pasted in an MS Excel file.

[lbendlin]

Your tag will always compute to false, as the tag can only be A OR B, not A and B.  You were looking for "contains" maybe ?

[Kenzaobd99]

unfortunately it's not a "contains", tags are made up of a single word

[lbendlin]

Then switch to "OR"

[gk2go]

She is asking for AND. How to get to those rows that have both A AND B, not A or B. 

[lbendlin]

That would only work if you use advanced filtering in the filter pane, or many disconnected tables.

[gk2go]

even advanced filtering doesn't work, you can try the pbix file. 

What do you mean by disconnected tables, do you have a specific solution to propose?

[lbendlin]

The PBIX does not have sufficient data for a DAX solution - the tags are not contained in the title.  If you want fuzzy matching you need to use Power Query or external tools.