calculate outliers from upper bound and lower bound that changes with filters.

[bharosha]

I have dataset below. 

I need to calculate outliers based on upperbound and lowerbound that changes when I click on filters. 

I want to filter for Applicable and Policy, outliers to be calculated by FY of time to report (days)

I was able to calculate the outliers, but it does not change when I filter the page to be Applicable to "Yes". The outlier stays the same. As upper bound and lower bound changes when we change the dataset by selected Applicable to "Yes", outlier needs to be changes as well. 

NCT ID	Time to Report (Days)	FY	Applicable	Policy
1	210	FY2020	Yes	No
2	348	FY2020	Yes	No
3	433	FY2020	Yes	No
4	-995	FY2020	Yes	No
5	212	FY2020	Yes	No
6	265	FY2021	Yes	No
7	563	FY2020	Yes	No
8	410	FY2020	Yes	No
9	448	FY2021	Yes	No
10	238	FY2020	Yes	No
11	674	FY2020	Yes	No
12	396	FY2020	Yes	No
13	454	FY2020	Yes	No
14	349	FY2020	Yes	No
15	245	FY2020	Yes	No
16	400	FY2021	Yes	No
17	443	FY2020	Yes	No
18	410	FY2021	Yes	No
19	-974	FY2020	Yes	No
20	364	FY2021	Yes	No
21	690	FY2020	Yes	No
22	461	FY2020	Yes	No
23	364	FY2021	Yes	No
24	454	FY2021	Yes	No
25	353	FY2021	Yes	No
26	777	FY2020	Yes	No
27	360	FY2020	Yes	No
28	434	FY2021	Yes	No
29	415	FY2021	Yes	No
30	385	FY2021	Yes	No
31	339	FY2021	Yes	No
32	358	FY2021	Yes	No
33	569	FY2020	Yes	No
34	766	FY2020	Yes	No
35	399	FY2021	Yes	No
36	370	FY2021	Yes	No
37	386	FY2020	Yes	No
38	711	FY2020	Yes	No
39	333	FY2021	Yes	No
40	249	FY2020	Yes	No
41	345	FY2021	Yes	No
42	670	FY2021	Yes	No
43	407	FY2021	Yes	No
44	364	FY2021	Yes	No
45	255	FY2020	Yes	No
46	405	FY2021	Yes	No
47	366	FY2020	Yes	No
48	408	FY2021	Yes	No
49	112	FY2020	Yes	No
50	465	FY2021	Yes	No
51	327	FY2021	Yes	No
52	314	FY2020	Yes	No
53	360	FY2020	Yes	No
54	346	FY2020	Yes	No
55	413	FY2021	Yes	No
56	347	FY2020	Yes	No
57	355	FY2020	Yes	No
58	349	FY2020	Yes	No
59	229	FY2020	Yes	No
60	559	FY2020	Yes	No
61	220	FY2020	Yes	No
62	320	FY2020	Yes	No
63	304	FY2021	Yes	No
64	330	FY2020	Yes	No
65	370	FY2021	Yes	No
66	288	FY2021	Yes	No
67	692	FY2020	Yes	No
68	382	FY2021	Yes	No
69	373	FY2020	Yes	No
70	403	FY2020	Yes	No
71	449	FY2021	Yes	No
72	456	FY2021	Yes	No
73	408	FY2020	Yes	No
74	259	FY2020	Yes	No
75	287	FY2020	Yes	No
76	485	FY2021	Yes	No
77	247	FY2020	Yes	No
78	360	FY2020	Yes	No
79	398	FY2020	Yes	No
80	386	FY2020	Yes	No
81	249	FY2020	Yes	No
82	381	FY2020	Yes	No
83	433	FY2020	Yes	No
84	548	FY2021	Yes	No
85	250	FY2021	Yes	No
86	188	FY2020	Yes	No
87	343	FY2020	Yes	No
88	119	FY2021	Yes	No
89	375	FY2020	Yes	No
90	714	FY2021	Yes	No
91	242	FY2021	Yes	No
92	366	FY2021	Yes	No
93	366	FY2021	Yes	No
94	957	FY2020	Yes	No
95	377	FY2021	Yes	No
96	448	FY2020	Yes	No
97	341	FY2021	Yes	No
98	415	FY2020	Yes	No
99	366	FY2021	Yes	No
100	728	FY2021	Yes	No
101	388	FY2020	Yes	No
102	566	FY2020	Yes	No
103	344	FY2020	Yes	No
104	727	FY2020	Yes	No
105	651	FY2021	Yes	No
106	293	FY2020	Yes	No
107	690	FY2021	Yes	No
108	357	FY2021	Yes	Yes
109	713	FY2020	Yes	No
110	369	FY2021	Yes	No
111	752	FY2021	Yes	Yes
112	368	FY2020	Yes	Yes
113	440	FY2020	Yes	No
114	715	FY2021	No	Yes
115	370	FY2021	Yes	Yes
116	1051	FY2021	Yes	No
117	274	FY2021	Yes	No
118	287	FY2021	Yes	No
119	209	FY2021	No	Yes
120	418	FY2021	Yes	Yes
121	593	FY2020	No	Yes
122	334	FY2021	Yes	Yes
123	516	FY2021	Yes	Yes
124	243	FY2021	Yes	Yes
125	280	FY2021	Yes	Yes
126	129	FY2020	No	Yes
127	340	FY2021	Yes	Yes
128	366	FY2020	Yes	Yes
129	309	FY2020	No	Yes
130	133	FY2020	Yes	Yes
131	539	FY2021	Yes	No
132	342	FY2021	No	Yes
133	389	FY2021	No	Yes
134	1239	FY2020	Yes	No
135	146	FY2020	No	Yes
136	306	FY2021	Yes	Yes
137	287	FY2020	Yes	Yes
138	254	FY2021	No	Yes
139	390	FY2021	Yes	Yes
140	523	FY2021	Yes	No
141	374	FY2021	Yes	Yes
142	434	FY2021	Yes	Yes
143	316	FY2021	Yes	Yes
144	289	FY2021	Yes	Yes
145	793	FY2021	No	Yes
146	247	FY2021	Yes	Yes
147	511	FY2021	Yes	Yes
148	565	FY2020	Yes	No
149	606	FY2021	Yes	No
150	886	FY2020	Yes	No
151	697	FY2020	Yes	No
152	858	FY2021	Yes	No
153	846	FY2021	Yes	No
154	556	FY2020	Yes	No
155	727	FY2020	Yes	No

[Anonymous]

Hi @bharosha,

Can you please share some dummy data that keep the raw data structure and dax expressions with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng