Forum Discussion
How do you create an "OR" filter?
Power BI filters are this "AND"ing of fields. You can apply the setup of filters for the visual, for the Page, or for the Report.
What if you have "OR" logic you need to handle. Take the following example:
Last Login > X | Last Login < X | |
Completed = Yes | Include | Include |
Completed = No | Exclude | Include |
There are a bunch of records to include, but when two conditions occur then exclude those records.
Secondly, I want the date (X) to be variable like from a time slicer.
How is this best done in Power Bi? I’m guessing this will be a new column.
5 Replies
- amitchandak
Super User
Please share some sample data and expected results
Today = 2/3/2020 Example:
X = 30 days
Last Login Completed Result 1/1/2020 No Exclude 1/1/2020 Yes Include 1/2/2020 No Exclude 1/2/2020 Yes Include 1/4/2020 No Include 1/4/2020 Yes Include 1/21/2020 No Include 1/22/2020 Yes Include - amitchandak
Try
Measure = if(Sumx(Sheet1,if(Sheet1[Last Login]>=maxx('Date',DATEADD('Date'[Date],-30,DAY)),1,if(Sheet1[Last Login]<maxx('Date',DATEADD('Date'[Date],-30,DAY)) && Sheet1[Completed] ="Yes",1,0)))=1,"Include","Exclude")Link :https://www.dropbox.com/s/jl2jjl9v2g8tabu/include_exclude.pbix?dl=0
- az38
Community Champion
Hi RandomJoe
for your scenario its better to use DAX logic.
for example, you can create calculated column like, then filter by its value
filterFlag = SWITCH(TRUE(), [Completed] = "Yes", "Include", [Completed] = "No" && [Last Login] > [X], "Exclude", "Include" )do not hesitate to give a kudo to useful posts and mark solutions as solution
