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]))
)

0 4 162
4 REPLIES 4
Top Labels in this Space