Forum Discussion

Maryann's avatar
Maryann
Helper I
6 years ago
Solved

Or Condition on filter

How can I allow the user to select what date they want to see the data filtered by , depending on 2 columns: Select data where date A = value (or range) or Date B = value (or range)
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Maryann ,

     

    We can archieve your requirement in single visual if you mean the two columns are in the same table. Firstly we create two calculated table based on the two columns:

     

    FilterColumnA = 
DISTINCT('Table'[Date A])

     

    FilterColumnB = 
DISTINCT('Table'[Date B])

     

    Then we create a measure to filter the visual:

     

    isDataFiltered =
COUNTAX (
    'Table',
    IF (
        OR (
            [Date A] IN FILTERS ( 'FilterColumnA'[Date A] ),
            [Date B] IN FILTERS ( 'FilterColumnB'[Date B] )
        ),
        1,
        BLANK ()
    )
)

     

    Then we can put it into the visual filter then set it is greater than zero.

     

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Maryann ,

 

We can archieve your requirement in single visual if you mean the two columns are in the same table. Firstly we create two calculated table based on the two columns:

 

FilterColumnA = 
DISTINCT('Table'[Date A])

 

FilterColumnB = 
DISTINCT('Table'[Date B])

 

Then we create a measure to filter the visual:

 

isDataFiltered =
COUNTAX (
    'Table',
    IF (
        OR (
            [Date A] IN FILTERS ( 'FilterColumnA'[Date A] ),
            [Date B] IN FILTERS ( 'FilterColumnB'[Date B] )
        ),
        1,
        BLANK ()
    )
)

 

Then we can put it into the visual filter then set it is greater than zero.

 

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Maryann's avatar
Maryann
Helper I
6 years ago

I'm new to powerbi, and I'm not sure exactly how to follow your instructions.

You said to "create two calculated tables"  -  Is that in Modeling -  New table? 

When I do that I get:    1 TABLE =    

(not sure where FilterColumnA goes)  

If you could provide more direction it would be appreciated.

thanks

  • Maryann's avatar
    Maryann
    Helper I
    6 years ago

    sorry, i didn't realize you sent an attachemnt.  That helps alot.  You can disregard previous question. I'll let you know if I need help.

    thanks

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi Maryann ,


      How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

       

      Best regards,

      Community Support Team _ Dong Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Maryann's avatar
        Maryann
        Helper I
        6 years ago

        Yours works fine.   But mine does not. So I must not have something set correctly. Still working on it.

        thanks