Forum Discussion

omelei86's avatar
omelei86
Frequent Visitor
4 years ago

Applying OR Filter

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..

Need Help

3 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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