Forum Discussion
Slicers and OR statement
- 3 years ago
hi Julian_H
check this blog
https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/
Hope this helps:
Thank you for coming back.
Sorry that not it thats just selecting item in a row
I have two columns and I need the user to be able to check in both columns and bring back the data if their selections are in either column.
Thank you again
- Padycosmos3 years agoSolution Sage
Could you paste some sample data or share the pbix file, if the data is not sensitive?
- Julian_H3 years agoHelper II
Sorry the data is sensitive but here's a mock up
Account Name 1 Name 2 123 John Peter 456 Mary David 789 Peter Paul So from the slicer(s) the user for example wants all data where Name 1 = John and Name 2 = Paul
So in this instance you would get a list showing account no's 123 and 789
- FreemanZ3 years agoSuper User
hi Julian_H
check this blog
https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/