Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Complex Filter Logic Using "AND" and "OR"

Very new to Power BI. Please explain throughly and with examples if possible. Page/Visualtion filters in the filter pane only allow for me to use "And" logic between filters. How do I filter a fie...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  Anonymous 

    I would sugget you create a new calculated column for conditional(1 OR 2 OR 3)

    FLAG=IF([Sales Rep - Product A] = "John Smith"
            || [Sales Rep - Product ] = "John Smith"
            || [Sales Rep - Product C] = "John Smith" ,1,0)

    Then use this column in Page/Visualtion filters to set filter is '1'.

     

    Regards,

    Lin

sravikrishnan's avatar
sravikrishnan
New Member
1 year ago

Hi I am very new to power BI. I have read the previous example and have a similar problem. Was hoping for 2 things

1. Someone would send me the code to use.

2. Guide me on where and how to use it (maybe screenshots)

 

I have about 5 source fields. All the fields are drop down with multiple values

 

I need a way to say show me all the records where

source field A = ecommerce or SF OR source fieldf B = ecommerce or Sf or Twine  OR source field C = ecommerce or sf or twine or ABC

 

ie. each field has a choice of several values and there are several such values.

 

Thanks in advance

v-lili6-msft smpa01 PaulDBrown 

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
1 year ago

A sample data source with clearly laid out end result would help.