How to use measure as a slicer

DAX DAX Calculations
13

Hi @nainiu440 and @Nick_M,
I’m not sure if I understand the question completely but, filtering a measure using a slicer is possible. I’ve taken the liberty of downloading your sample file and re-working the calculations to demonstrate how it would work with your data (refer to Page 2). The filtering of the measure is created by this function.

Count of Tasks with Outlier Filter = 
Var Dist_Table = 
ADDCOLUMNS(
    SUMMARIZE(demo,
    demo[TaskName]),
    "Test", [Outlier Test]
)
return
SUMX(
    FILTER(Dist_Table,
    CONTAINSROW( VALUES('Outlier supporting'[groups]), [Test])),
    1
)

I also simplified the Outlier measure to this.

Outlier Test = SWITCH(TRUE(),

And([New Z Score]>-1,[New Z Score]<1),“False”,

“True”)

and when you want to filter a measure you would apply it like this.

Task Start with Outlier Filter =

CALCULATE([Task Start],
FILTER(
VALUES(demo[TaskName]),
NOT ISBLANK([Count of Tasks with Outlier Filter])
)
)

I’m not sure that this completely answers the question because I don’t understand the relationship between “Districts” and “Projects” with the “Task”. Let me know if you have any questions. 20190830.pbix (358.0 KB)