Adding additional filter to row filter condition expression

I have a slice with this expression below under row filter condition, I need to add 2 filters but don’t know how to. The filters will be [Milestone]<>“15 Milestone Log” and [Milestone]<>“00 Prequal”
Please help :-).

AND(
IF(ISBLANK(ANY(Conditions Filter View[Status])), TRUE,[Status]=ANY(Conditions Filter View[Status])),

IF(ISBLANK(ANY(Conditions Filter View[Active Customer])), TRUE, [Customer]=ANY(Conditions Filter View[Active Customer])),

IF(ISBLANK(ANY(Conditions Filter View[Owner])), TRUE, [Owner]=ANY(Conditions Filter View[Owner])),

IF(ISBLANK(ANY(Conditions Filter View[Coordinating])), TRUE, [Coordinating]=ANY(Conditions Filter View[Coordinating])),

IF(ISBLANK(ANY(Conditions Filter View[3rd Party])), TRUE, [3rd Party]=ANY(Conditions Filter View[3rd Party])),

IF(ISBLANK(ANY(Conditions Filter View[Priority])), TRUE, [Priority]=ANY(Conditions Filter View[Priority])),

IF(ISBLANK(ANY(Conditions Filter View[Section])), TRUE, [Section]=ANY(Conditions Filter View[Section]))
)

It really depends on how you wish the conditions to work in filters. But for a simple AND() level it could be as below, presuming [Milestone] column is NOT from “Conditions Filter View” .

AND(
**[Milestone]<>“15 Milestone Log” ,

[Milestone]<>“00 Prequal”,

IF(ISBLANK(ANY(Conditions Filter View[Status])), TRUE,[Status]=ANY(Conditions Filter View[Status])),

IF(ISBLANK(ANY(Conditions Filter View[Active Customer])), TRUE, [Customer]=ANY(Conditions Filter View[Active Customer])),

IF(ISBLANK(ANY(Conditions Filter View[Owner])), TRUE, [Owner]=ANY(Conditions Filter View[Owner])),

IF(ISBLANK(ANY(Conditions Filter View[Coordinating])), TRUE, [Coordinating]=ANY(Conditions Filter View[Coordinating])),

IF(ISBLANK(ANY(Conditions Filter View[3rd Party])), TRUE, [3rd Party]=ANY(Conditions Filter View[3rd Party])),

IF(ISBLANK(ANY(Conditions Filter View[Priority])), TRUE, [Priority]=ANY(Conditions Filter View[Priority])),

IF(ISBLANK(ANY(Conditions Filter View[Section])), TRUE, [Section]=ANY(Conditions Filter View[Section]))
)

2 Likes

Thanks bud, yes, it took care of it :slight_smile: Thanks for taking the time

Cheers

1 Like

You are welcome. However, you may note a general guideline for better app sync performance that equality operators are preferred over inequality operators. So if there are just three or four options for [MileStone] , then it could be better to include in expression something like

OR( [Milestone] =“30 Milestone Log”, [Milestone] =“45 Milestone Log”) , assuming these are other possible values of [MileStone]

Again the sync performance is a somewhat complex topic because it is a combination of many factors.
Hope the below post helps

1 Like

Your expression reformatted for my clarity:

AND(
  IF(
    ISBLANK(ANY(Conditions Filter View[Status])),
    TRUE,
    [Status]=ANY(Conditions Filter View[Status])
  ),
  IF(
    ISBLANK(ANY(Conditions Filter View[Active Customer])),
    TRUE,
    [Customer]=ANY(Conditions Filter View[Active Customer])
  ),
  IF(
    ISBLANK(ANY(Conditions Filter View[Owner])),
    TRUE,
    [Owner]=ANY(Conditions Filter View[Owner])
  ),
  IF(
    ISBLANK(ANY(Conditions Filter View[Coordinating])),
    TRUE,
    [Coordinating]=ANY(Conditions Filter View[Coordinating])
  ),
  IF(
    ISBLANK(ANY(Conditions Filter View[3rd Party])),
    TRUE,
    [3rd Party]=ANY(Conditions Filter View[3rd Party])
  ),
  IF(
    ISBLANK(ANY(Conditions Filter View[Priority])),
    TRUE,
    [Priority]=ANY(Conditions Filter View[Priority])
  ),
  IF(
    ISBLANK(ANY(Conditions Filter View[Section])),
    TRUE,
    [Section]=ANY(Conditions Filter View[Section])
  )
)

Replace IF() with OR():

AND(
  OR(
    ISBLANK(ANY(Conditions Filter View[Status])),
    [Status]=ANY(Conditions Filter View[Status])
  ),
  OR(
    ISBLANK(ANY(Conditions Filter View[Active Customer])),
    [Customer]=ANY(Conditions Filter View[Active Customer])
  ),
  OR(
    ISBLANK(ANY(Conditions Filter View[Owner])),
    [Owner]=ANY(Conditions Filter View[Owner])
  ),
  OR(
    ISBLANK(ANY(Conditions Filter View[Coordinating])),
    [Coordinating]=ANY(Conditions Filter View[Coordinating])
  ),
  OR(
    ISBLANK(ANY(Conditions Filter View[3rd Party])),
    [3rd Party]=ANY(Conditions Filter View[3rd Party])
  ),
  OR(
    ISBLANK(ANY(Conditions Filter View[Priority])),
    [Priority]=ANY(Conditions Filter View[Priority])
  ),
  OR(
    ISBLANK(ANY(Conditions Filter View[Section])),
    [Section]=ANY(Conditions Filter View[Section])
  )
)
1 Like