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]))
)
Thanks bud, yes, it took care of it Thanks for taking the time
Cheers
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
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])
)
)
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
16 |