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

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
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