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]))
)
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |