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

     

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