Forum Discussion
Or Condition on filter
- 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.
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.
Thank you! I'll try it out ,and reply later today.