Solved: Using OR at Visual Level Filter

sabeensp · ‎08-13-2019

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.

AlB · ‎08-13-2019

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

AlB · ‎08-13-2019

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

Using OR at Visual Level Filter