Forum Discussion

sabeensp's avatar
sabeensp
Icon for Helper IV rankHelper IV
7 years ago
Solved

Using OR at Visual Level Filter

Hello,

I have a very simple question.

I have a grid which has few columns. I need to apply a OR filter to the grid.

Column A <> 'USD'
OR
Column B <> 'GBP'

If I simply do to Basic Filter then isn't PBI treat that as "AND" condition?
Thanks for your help.

Need Help
  • AlB's avatar
    AlB
    7 years ago

    Hi sabeensp 

    Try this:

    1. Create a measure:

    ShowMeasure =
IF (
    SELECTEDVALUE ( Table1[Column1] ) <> "USD"
        || SELECTEDVALUE ( Table1[Column2] ) <> "GBP";
    1
)

    2. Place the Column1 and Column2 in a table visual

    3. Place the measure in the visual filter and choose to show when ShowMeasure is 1 

     

    Cheers

     

1 Reply

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi sabeensp 

    Try this:

    1. Create a measure:

    ShowMeasure =
IF (
    SELECTEDVALUE ( Table1[Column1] ) <> "USD"
        || SELECTEDVALUE ( Table1[Column2] ) <> "GBP";
    1
)

    2. Place the Column1 and Column2 in a table visual

    3. Place the measure in the visual filter and choose to show when ShowMeasure is 1 

     

    Cheers