Or Condition on filter

[Maryann]

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)

[v-lid-msft · Accepted solution]

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]

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]

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]

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]

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

thanks

[Maryann]

Thank you!  I'll try it out ,and reply later today.