Applying OR Filter

[omelei86]

Hi 

I am relatively new to PowerBI. Hope you can help. 

Table Opportunities

Opportunity ID	Sales Team (coming from Opp owner)	Sales Team (coming from Revenue responsible)
XjxjxjxhxA	Team A	Team A
XjxjxjxhxB	Team B	Team B
XjxjxjxhxC	Team A	Team B
XjxjxjxhxD	Team B	Team A

Now I'd like to apply a Filter visual on Sales team. However, it should filter on both columns. 

Let's say we filter on Sales Team = Team A, the expected result should be:

Opportunity ID	Sales Team (coming from Opp owner)	Sales Team (coming from Revenue responsible)
XjxjxjxhxA	Team A	Team A
XjxjxjxhxC	Team A	Team B
XjxjxjxhxD	Team B	Team A

Any idea? Thanks in advance..

[Anonymous]

Hi @omelei86,

Current power bi does not support the 'OR' logic filter, you can create an unconnected table as the source of the slicer.
Then you can write a measure formula to extract the selection from the filter and compare it with current records and return flags, this formula can be used on the 'visual level filter' to filter records.

Regards,

Xiaoxin Sheng

[Ashish_Mathur]

Hi,

Write a RELATED() function in Table2 to bring over the Sales Team column from Table1.  Create your visuals from Table2.

[Fowmy]

@omelei86 

Hope the following video could be of help; 
https://www.youtube.com/watch?v=WFJThyfQt-A