Forum Discussion
AND OR on Filter Pane
Is there a way you can create a filter grouping which can handle an AND OR Clauses?
Example:
Filter 1: Created Date
Fiter 2: Apponintment = True
OR
Filter 3: Booked by Role = BDR
Filter 4: Activity Type = First Presentation Booked
So it would be (Filter 1 AND Filter 2) OR (Filter 3 AND Filter 4)
Try use varibles to group filters? Something like below.result = var filtergroup1= Calculate(sum(Table[column1]),filter(Table[Created Date]<="date")&&Table[Apponintment] = True()) var filtergroup2 = Calculate(sum(Table[column1]),filter(Table[Booked by Role] = "BDR")&&Table[Activity Type = "First Presentation Booked") Return Calculate(sum(column1),Filter(Table,filtergroup1 || filtergroup2)Paul Zheng
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!
2 Replies
- amitchandak
Super User
Please find examples'
AND CALCULATE(MAX(Table[Date]),FILTER(Data,Table[ID]=EARLIER(Table[ID])&&Table[Date]<EARLIER(Table[Date]))) OR CALCULATE(MAX(Table[Date]),FILTER(Data,Table[ID]=EARLIER(Table[ID]) || Table[Date]<EARLIER(Table[Date]))) CALCULATE(MAX(Table[Date]),FILTER(Data,(Table[ID]=EARLIER(Table[ID])&& Table[Date]<EARLIER(Table[Date])) || (Table[ID1]=EARLIER(Table[ID1])&& Table[Date1]<EARLIER(Table[Date1]))))Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Try use varibles to group filters? Something like below.result = var filtergroup1= Calculate(sum(Table[column1]),filter(Table[Created Date]<="date")&&Table[Apponintment] = True()) var filtergroup2 = Calculate(sum(Table[column1]),filter(Table[Booked by Role] = "BDR")&&Table[Activity Type = "First Presentation Booked") Return Calculate(sum(column1),Filter(Table,filtergroup1 || filtergroup2)Paul Zheng
Don't forget to hit THUMBS UP and mark it as a solution if it helps you!
