Forum Discussion
Solved
OR Filter with Power BI
I have a task to create a OR Slicer, Means if I pick any Region and City , the output should be OR type, I get all the rows with either Selected City or Region, in order to solve this problem I creat...
This helped me
I had to make unconnected tables here, Slicer Region and City tables with only column
OR Solution = IF( SELECTEDVALUE('Slicer Region Table'[Region])= MAX(Orders[Region])||SELECTEDVALUE('Slicer city Table'[city])= MAX(Orders[City]),1,0)
Hey kipi_bi ,
implementing OR filtering is explained by the people from sql.bi in this article: Using OR conditions between slicers in DAX - SQLBI
Hopefully, this provides you with some ideas of how to tackle your challenge.
Regards,
Tom
hi TomMartens
I had seen this link already but could not get the answer, here is my file https://drive.google.com/file/d/1BQSu5XEM7yaaYCDcY1KmepbSaAe73ies/view?usp=sharing , it will be great if you can see what went wrong, thanks in advanceRitz