Static Measure-ALL() and Removefilters() not working

Question

I am working with Power BI and facing an issue with calculating turnover rates based on tenure buckets while keeping the average headcount for the last 12 months consistent across different tenure ranges. Specifically, the turnover rate should always use a static average headcount value, but the current setup causes the average headcount to vary based on the tenure bucket slicer applied.

Turnover Rate = terms_last_12months / avg headcount last_12months

Issue: When I place the avg headcount last_12months measure on a table with tenure buckets and terminations by tenure bucket, the average headcount value is being broken down by the tenure bucket slicer, rather than remaining static.
Desired Outcome: I want the avg headcount last_12months to remain static and consistent across all tenure buckets, regardless of the tenure bucket filter applied. This static average headcount should be used as the denominator in the turnover rate calculation, while the terminations should be accurately calculated based on the tenure bucket.
Consistency Check: If the turnover rate shows, for example, 50.1% on a card, the sum of the turnover rates when broken down by tenure range should also total 50.1%. The calculated turnover rates by tenure bucket should match the overall turnover rate displayed on the card.

Attempted Solutions

Using REMOVEFILTERS: Attempted to keep the average headcount static by removing filters on tenure buckets and dates, but this did not work as expected.
Using ALL and ALLSELECTED Functions: Tried various combinations of these functions to achieve a static average headcount, but encountered issues with maintaining the static nature across different contexts.
Creating a Static Table: Tried using a static table with a hardcoded value, but this is not ideal and does not update dynamically with the data.

I believe the best way to solve my situation is to make "avg headcount last_12months" static - please assist with this or show me another approach.

rajendraongole1 · Answer

Hi&nbsp;jaylyn&nbsp;-&nbsp;create a measure that calculates the average headcount over the last 12 months without being affected by the tenure bucket slicer.
Static Avg Headcount Last 12 Months = CALCULATE([Avg Headcount Last 12 Months], REMOVEFILTERS('Tenure Table'[Tenure Bucket]))
&nbsp;
use the static average headcount measure in your turnover rate calculation measure
Turnover Rate = DIVIDE([Terms Last 12 Months],[Static Avg Headcount Last 12 Months],0)
&nbsp;
Hope this works, still issue exist, please share the sample data for reference .

jaylyn · Answer

Hi, Raj-&nbsp;i did do that but it's still behaving the same, it really doesn't make sense that the removefilters isn't working. Here is a calculation of my avg hc last 12M just to make sure it's not the problem:&nbsp;Active-1ago = CALCULATE(&nbsp; &nbsp; DISTINCTCOUNT('Employee'[EED]),&nbsp; Employee[Hiredate] &lt;= EOMONTH(MAX('Date'[Date]), -1) &amp;&amp;&nbsp; Employee[TerminationDate]&gt; EOMONTH(MAX('Date'[Date]), -1))&nbsp;----Active-10ago = CALCULATE(&nbsp; &nbsp; DISTINCTCOUNT('Employee'[EEID]),&nbsp; Employee[Hiredate] &lt;= EOMONTH(MAX('Date'[Date]), -10) &amp;&amp;&nbsp; Employee[Termination_Date]&gt; EOMONTH(MAX('Date'[Date]), -10))&nbsp;i have this measure 12x (including current-month) - each time i'm changing the -10 to -2 or -3 and etc.&nbsp;&nbsp;avg headcount last_12months =([Active] +[Active-1ago] + [Active-2ago] + [Active-3ago] + [Active-4ago] +[Active-5ago] +[Active-6ago] +[Active-7ago] +[Active-8ago] +[Active-9ago]+[Active-10ago] +[Active-11ago])/ 12//calculates avg HC for last 12 months, including current month&nbsp;&nbsp;here is my tenure bucket:&nbsp;Tenure bucket =SWITCH(&nbsp; &nbsp; TRUE(), Employee[TenureMonth] &lt;= 3, " &nbsp;0-3 Months",&nbsp; &nbsp; Employee[TenureMonth] &lt;= 6, " &nbsp;3-6 Months",&nbsp; &nbsp; Employee[TenureMonth] &lt;= 9, " &nbsp;6-9 Months",&nbsp; &nbsp; Employee[TenureMonth] &lt;= 12, " 9-12 Months",&nbsp; &nbsp; Employee[TenureMonth] &lt;= 18, "12-18 Months",&nbsp; &nbsp; Employee[TenureMonth] &lt;= 24, "18-24 Months",&nbsp; &nbsp; Employee[TenureMonth] &lt;= 30, "24-30 Months",&nbsp; &nbsp; Employee[TenureMonth] &lt;= 36, "30-36 Months",&nbsp; &nbsp; Employee[TenureMonth] &lt;= 42, "36-42 Months",&nbsp; &nbsp; Employee[TenureMonth] &lt; 48, "42-48 Months",&nbsp; &nbsp; TRUE(), " &nbsp; 48+ Months" &nbsp;// Adjusted to three spaces before "48+ Months")

jaylyn · Answer

sample data:thank you!&nbsp;Tenure bucketEEID&nbsp;TenureMonthTerminationDateHiredate&nbsp; 0-3 Months133/22/20211/4/2021&nbsp; 0-3 Months212/5/20211/11/2021&nbsp; 0-3 Months317/6/20215/31/2021&nbsp; 0-3 Months418/3/20217/12/2021&nbsp; 0-3 Months5211/23/20219/13/2021&nbsp; 0-3 Months621/24/202211/15/2021&nbsp; 0-3 Months713/9/20221/31/2022&nbsp; 0-3 Months812/18/20221/24/2022&nbsp; 0-3 Months904/26/20224/26/2022&nbsp; 0-3 Months1018/26/20228/8/2022&nbsp; 0-3 Months11211/4/20228/22/2022&nbsp; 0-3 Months1209/3/20228/29/2022&nbsp; 0-3 Months1334/30/20232/6/2023&nbsp; 0-3 Months14310/26/20237/31/2023&nbsp; 0-3 Months15212/22/202310/16/2023&nbsp; 0-3 Months1623/22/20242/5/2024&nbsp; 0-3 Months1702/22/20242/15/2024&nbsp; 3-6 Months1855/3/202111/30/2020&nbsp; 3-6 Months1934/9/202112/28/2020&nbsp; 3-6 Months20512/7/20216/28/2021&nbsp; 3-6 Months2154/1/202210/25/2021&nbsp; 3-6 Months2253/25/202211/1/2021&nbsp; 3-6 Months2368/8/20222/14/2022&nbsp; 3-6 Months2449/2/20225/2/2022&nbsp; 3-6 Months2562/21/20239/7/2022&nbsp; 3-6 Months2653/10/202310/10/2022&nbsp; 3-6 Months2766/30/20231/2/2023&nbsp; 3-6 Months2862/27/20249/11/2023&nbsp; 3-6 Months2955/15/202412/11/2023&nbsp; 6-9 Months3092/18/20226/7/2021&nbsp; 6-9 Months3172/14/20228/2/2021&nbsp; 6-9 Months3277/21/20211/4/2021&nbsp; 6-9 Months3376/13/202211/29/2021&nbsp; 6-9 Months3466/3/202211/29/2021&nbsp; 6-9 Months35610/17/20224/18/2022&nbsp; 6-9 Months36812/31/20225/9/2022&nbsp; 6-9 Months3782/28/20237/5/2022&nbsp; 6-9 Months3869/9/20233/6/2023&nbsp; 6-9 Months39912/30/20234/14/2023&nbsp; 6-9 Months4071/8/20246/26/2023&nbsp; 6-9 Months4173/21/20249/5/2023&nbsp; 6-9 Months4285/10/20249/5/2023&nbsp; 6-9 Months4377/2/202412/11/2023&nbsp; 6-9 Months4477/28/20241/9/2024&nbsp;9-12 Months45106/25/20248/28/2023&nbsp;9-12 Months46113/1/20224/12/2021&nbsp;9-12 Months471110/25/202111/16/2020&nbsp;9-12 Months48104/30/20216/24/2020&nbsp;9-12 Months49112/4/20223/8/2021&nbsp;9-12 Months50101/24/20224/12/2021&nbsp;9-12 Months51124/15/20224/26/2021&nbsp;9-12 Months5295/9/20228/2/2021&nbsp;9-12 Months53128/19/20228/30/2021&nbsp;9-12 Months541010/8/202211/29/2021&nbsp;9-12 Months551011/2/20221/17/2022&nbsp;9-12 Months561011/14/20221/17/2022&nbsp;9-12 Months57105/2/20237/11/2022&nbsp;9-12 Months58116/2/20237/18/2022&nbsp;9-12 Months5996/30/20239/26/2022&nbsp;9-12 Months60129/16/20239/26/2022&nbsp;9-12 Months611110/13/202311/21/2022&nbsp;9-12 Months62115/18/20246/26/2023&nbsp;9-12 Months63117/19/20248/14/202312-18 Months64184/18/202210/29/202012-18 Months65174/19/202111/18/201912-18 Months66156/18/20213/23/202012-18 Months671711/23/20216/24/202012-18 Months681412/3/202110/5/202012-18 Months691210/29/202111/2/202012-18 Months70152/25/202212/14/202012-18 Months71165/13/20221/5/202112-18 Months72164/29/20221/4/202112-18 Months73147/29/20226/7/202112-18 Months741711/10/20226/7/202112-18 Months751610/11/20226/7/202112-18 Months761610/21/20226/21/202112-18 Months77126/10/20226/14/202112-18 Months78153/31/20231/10/202212-18 Months79133/31/20233/7/202212-18 Months80156/17/20233/16/202212-18 Months81137/14/20236/6/202212-18 Months82159/8/20236/13/202212-18 Months831410/7/20238/17/202212-18 Months841612/21/20238/22/202212-18 Months85172/14/20249/19/202212-18 Months86143/29/20242/6/202312-18 Months87135/18/20244/24/202312-18 Months88137/13/20246/12/202312-18 Months89138/2/20247/24/202318-24 Months90227/30/202110/7/201918-24 Months91206/11/202110/8/201918-24 Months92239/2/202210/5/202018-24 Months93201/13/20235/24/202118-24 Months94201/1/20235/24/202118-24 Months95223/21/20235/27/202118-24 Months96203/11/20237/5/202118-24 Months97238/18/20239/13/202118-24 Months98237/28/20238/23/202118-24 Months99182/25/20238/24/202118-24 Months100196/9/202311/18/202118-24 Months101219/1/202311/29/202118-24 Months1022110/23/20231/17/202218-24 Months103219/29/20231/17/202218-24 Months104191/31/20247/11/202218-24 Months105203/15/20247/18/202218-24 Months106192/29/20247/25/202218-24 Months107203/19/20248/1/202218-24 Months108215/10/20248/8/202218-24 Months109216/5/20249/26/202224-30 Months110294/16/202112/12/201824-30 Months111261/5/202212/2/201924-30 Months112252/2/20221/20/202024-30 Months113299/30/20235/17/202124-30 Months1142910/26/20236/7/202124-30 Months115263/15/20241/17/202224-30 Months116263/8/20241/17/202224-30 Months117267/10/20245/23/202224-30 Months118268/2/20246/29/202224-30 Months119257/31/20247/18/202230-36 Months120336/21/20249/22/202130-36 Months121334/8/20238/3/202030-36 Months122321/30/20246/28/202130-36 Months123356/1/20247/5/202130-36 Months124303/19/20249/20/202136-42 Months1254211/24/20236/24/202036-42 Months126385/1/20213/5/201836-42 Months1273610/7/202210/12/201936-42 Months1283710/28/202210/12/201936-42 Months1293710/28/202210/12/201936-42 Months130401/14/202310/12/201936-42 Months1313710/28/202210/12/201942-48 Months132442/25/20227/2/201842-48 Months133477/19/20229/17/201842-48 Months134467/15/202210/8/201842-48 Months135458/12/202211/19/2018&nbsp;&nbsp; 48+ Months1364099/30/20232/19/1990&nbsp;&nbsp; 48+ Months1373597/1/20241/11/1995&nbsp;&nbsp; 48+ Months1382861/28/20228/3/1998&nbsp;&nbsp; 48+ Months1391861/3/20229/11/2006&nbsp;&nbsp; 48+ Months1401523/8/20229/9/2009&nbsp;&nbsp; 48+ Months1411503/8/202310/28/2010&nbsp;&nbsp; 48+ Months142546/17/20241/6/2020&nbsp;&nbsp; 48+ Months1431479/30/20238/29/2011&nbsp;&nbsp; 48+ Months1441468/18/20238/29/2011&nbsp;&nbsp; 48+ Months14513410/1/20229/20/2011&nbsp;&nbsp; 48+ Months1461175/28/202110/31/2011&nbsp;&nbsp; 48+ Months1471263/21/202211/11/2011&nbsp;&nbsp; 48+ Months1481201/6/20232/18/2013&nbsp;&nbsp; 48+ Months14911811/11/20223/11/2013&nbsp;&nbsp; 48+ Months1501017/9/20213/29/2013&nbsp;&nbsp; 48+ Months1511018/2/20214/29/2013&nbsp;&nbsp; 48+ Months1521138/12/20225/6/2013&nbsp;&nbsp; 48+ Months1531117/1/20235/28/2014&nbsp;&nbsp; 48+ Months1541237/1/20245/19/2014&nbsp;&nbsp; 48+ Months155945/26/20228/25/2014&nbsp;&nbsp; 48+ Months1569912/30/202211/10/2014&nbsp;&nbsp; 48+ Months157744/27/20213/19/2015&nbsp;&nbsp; 48+ Months158736/5/20216/22/2015&nbsp;&nbsp; 48+ Months159749/29/20219/14/2015&nbsp;&nbsp; 48+ Months160768/14/20235/29/2017&nbsp;&nbsp; 48+ Months16112111/8/202112/12/2011&nbsp;&nbsp; 48+ Months1621051/3/20225/13/2013&nbsp;&nbsp; 48+ Months1638112/31/20215/18/2015&nbsp;&nbsp; 48+ Months1643232/1/20227/17/1995&nbsp;&nbsp; 48+ Months1652332/14/20221/6/2003&nbsp;&nbsp; 48+ Months16621610/3/20221/10/2005&nbsp;&nbsp; 48+ Months16719510/3/20219/21/2005&nbsp;&nbsp; 48+ Months1682184/27/20236/15/2005&nbsp;&nbsp; 48+ Months1694124/1/20235/29/1989&nbsp;&nbsp; 48+ Months1701986/17/20223/24/2006&nbsp;&nbsp; 48+ Months1711849/30/20218/11/2006&nbsp;&nbsp; 48+ Months1723816/1/20222/20/1991&nbsp;&nbsp; 48+ Months1733091/31/20249/21/1998&nbsp;&nbsp; 48+ Months1743114/30/202410/27/1998&nbsp;&nbsp; 48+ Months1753494/1/20238/15/1994&nbsp;&nbsp; 48+ Months1763299/25/20219/19/1994&nbsp;&nbsp; 48+ Months1777410/29/202110/12/2015&nbsp;&nbsp; 48+ Months178795/18/202311/7/2016&nbsp;&nbsp; 48+ Months1798410/4/202311/7/2016&nbsp;&nbsp; 48+ Months180625/11/20223/27/2017&nbsp;&nbsp; 48+ Months181625/26/20224/24/2017&nbsp;&nbsp; 48+ Months182609/2/20229/29/2017&nbsp;&nbsp; 48+ Months1831025/23/20241/11/2016&nbsp;&nbsp; 48+ Months184485/1/20215/21/2017&nbsp;&nbsp; 48+ Months185746/9/20235/21/2017&nbsp;&nbsp; 48+ Months1867612/16/20239/4/2017&nbsp;&nbsp; 48+ Months187845/27/20226/29/2015&nbsp;&nbsp; 48+ Months188814/19/20228/12/2015&nbsp;&nbsp; 48+ Months189948/4/202311/25/2015&nbsp;&nbsp; 48+ Months190577/16/202111/8/2016&nbsp;&nbsp; 48+ Months191628/29/20238/6/2018&nbsp;&nbsp; 48+ Months192685/31/202410/25/2018&nbsp;&nbsp; 48+ Months1936112/11/202312/17/2018&nbsp;&nbsp; 48+ Months194579/8/20231/7/2019&nbsp;&nbsp; 48+ Months195546/2/20231/7/2019&nbsp;&nbsp; 48+ Months196543/22/202410/23/2019&nbsp;&nbsp; 48+ Months197576/14/202410/12/2019&nbsp;&nbsp;

jaylyn · Answer

&nbsp;&nbsp;&nbsp;* disconnected date table (no relationship in data model with date and Employee table)* Terms last 12M shows correctly when placed on table with tenure bucket* turnover shows correctly when placed on table/card without the tenure bucket- when tenure bucket is added, it is spliced incorrectly&nbsp;* In this example, 13.2% is what i should get&nbsp;---------------------------terms_last_12months (new) = VAR currentdate = MAX('Date'[Date])VAR end_of_current_month = EOMONTH(currentdate, 0) &nbsp;VAR tweleve_month_ago_start = EOMONTH(end_of_current_month, -12) + 1RETURNCALCULATE(&nbsp; &nbsp; DISTINCTCOUNT(Employee[EEID]),&nbsp;Employee[TerminationDate] &gt;= tweleve_month_ago_start &amp;&amp;&nbsp; &nbsp;Employee[TerminationDate] &lt;= end_of_current_month)&nbsp;&nbsp;0-3Monthsterms last 12M = 4avg hc last 12 months = 470turnover = 4/470 = 0.851%3-6Monthsterms last 12M = 2avg hc last 12 months = 470turnover = 2/470 = 0.4255%6-9Monthsterms last 12M = 7avg hc last 12 months = 470turnover = 7/470 = 1.489%9-12Monthsterms last 12M = 5avg hc last 12 months = 470turnover = 5/470 =1.0638%12-18Monthsterms last 12M = 8avg hc last 12 months = 470turnover = 8/470 =1.702%18-24Monthsterms last 12M = 9avg hc last 12 months = 470turnover = 9/470 = 1.915%24-30Monthsterms last 12M = 7avg hc last 12 months = 470turnover = 7/470 = 1.489%30-36Monthsterms last 12M = 4avg hc last 12 months = 470turnover = 4/470 = 0.851%36-42Monthsterms last 12M = 1avg hc last 12 months = 470turnover = 1/470 = 0.213%48+Monthsterms last 12 months = 15avg hc last 12 months = 470turnover = 15/470 = 3.19%avg hc last 12M = 470term last 12 M = 62turnover = 62/470 =13.2%turnover % = 13.2%&nbsp;

jaylyn · Answer

sample data for avg hcEEDHiredateTerminationDate18/18/20031/1/209929/8/20031/1/209939/8/20031/1/2099410/20/19871/1/209951/2/20041/1/209964/7/19801/1/209975/17/19941/1/2099810/2/19881/1/209999/14/19941/1/2099102/28/20051/1/2099111/10/19951/1/2099121/11/19957/1/2024133/1/20211/1/2099147/7/19981/1/2099152/14/20111/1/2099161/29/19961/1/2099174/24/20061/1/2099185/27/19971/1/2099197/10/20061/1/20992010/1/20061/1/2099211/12/20071/1/2099223/26/20071/1/2099233/20/19981/1/2099244/3/20001/1/2099252/4/19991/1/20992610/9/20071/1/20992711/2/20071/1/2099286/7/20101/1/2099297/5/20111/1/20993011/26/20071/1/2099319/20/19991/1/2099321/2/20081/1/2099331/11/20081/1/2099345/8/20001/1/2099359/2/20081/1/2099369/9/20091/1/2099379/22/20091/1/2099385/1/20101/1/2099393/19/20071/1/20994010/2/20001/1/20994111/5/20071/1/2099421/8/20011/1/2099434/2/20011/1/20994411/9/20101/1/2099451/7/20081/1/20994611/5/20011/1/20994711/5/20011/1/2099481/6/20206/17/2024495/16/20111/1/2099505/23/20111/1/2099517/1/20111/1/2099527/11/20111/1/2099536/29/20111/1/2099547/11/20111/1/20995510/31/20111/1/20995610/31/20111/1/20995711/7/20111/1/2099581/30/20121/1/2099591/30/20121/1/2099602/6/20121/1/2099612/4/20191/1/2099629/17/20121/1/2099631/14/20131/1/2099641/14/20131/1/2099652/18/20131/1/2099663/25/20241/1/2099676/3/20131/1/2099689/16/20131/1/2099699/13/20131/1/20997010/14/20131/1/20997110/29/20131/1/20997212/9/20131/1/2099731/1/20141/1/2099741/6/20141/1/2099751/6/20141/1/2099761/20/20141/1/2099771/20/20141/1/2099781/21/20141/1/2099792/3/20141/1/2099802/17/20141/1/2099814/21/20141/1/2099823/24/20141/1/2099833/31/20141/1/2099846/24/202011/24/2023855/12/20141/1/2099867/8/20191/1/2099875/19/20147/1/2024886/2/20141/1/2099896/16/20141/1/2099907/14/20141/1/2099919/3/20141/1/2099928/25/20141/1/2099938/21/20141/1/2099947/1/20061/1/2099953/10/20031/1/20999610/20/20141/1/2099971/5/20151/1/2099984/27/20151/1/2099997/27/20151/1/20991006/1/20151/1/20991016/15/20151/1/20991027/6/20151/1/20991038/3/20151/1/20991048/3/20151/1/20991059/22/20216/21/202410611/2/20151/1/209910711/2/20151/1/20991082/8/20161/1/20991092/22/20161/1/20991102/22/20161/1/20991116/20/20161/1/20991127/11/20161/1/20991138/1/20161/1/20991148/28/20236/25/202411512/21/20161/1/20991162/6/20171/1/20991173/20/20171/1/20991184/24/20171/1/20991199/11/20171/1/209912010/23/20171/1/209912110/16/20171/1/209912210/30/20171/1/209912311/13/20171/1/20991241/29/20181/1/20991253/5/20181/1/20991265/7/20181/1/209912711/29/20101/1/20991288/8/20051/1/209912910/12/20091/1/20991303/15/20101/1/20991315/17/20101/1/20991327/5/20101/1/20991331/3/20111/1/20991343/21/20111/1/20991354/18/20111/1/20991364/25/20111/1/209913711/8/20231/1/20991387/4/20111/1/209913910/10/20111/1/209914012/19/20111/1/209914110/17/20231/1/209914211/5/20121/1/209914311/5/20121/1/209914412/3/20121/1/20991456/13/20131/1/209914611/11/20131/1/209914712/30/20131/1/20991488/22/20221/1/20991491/27/20141/1/20991504/28/20141/1/209915110/6/20141/1/209915210/20/20141/1/20991531/19/20151/1/20991542/9/20151/1/20991554/13/20151/1/20991564/20/20151/1/209915711/25/20021/1/20991585/29/20011/1/20991594/1/20041/1/20991604/26/20041/1/209916112/7/20011/1/20991621/7/20021/1/20991632/1/19991/1/20991642/25/20021/1/20991651/31/20001/1/209916610/1/20021/1/20991672/28/20031/1/209916810/11/20041/1/20991694/24/20061/1/20991705/1/20061/1/20991716/1/20061/1/20991722/15/19931/1/20991739/21/20061/1/209917411/1/20061/1/209917510/25/20061/1/20991765/15/20081/1/209917710/13/20081/1/209917811/3/20081/1/20991799/19/20111/1/20991802/1/20001/1/20991816/22/19851/1/20991829/21/19981/31/202418310/27/19984/30/20241849/14/20151/1/20991859/21/20151/1/209918611/12/20201/1/209918711/2/20151/1/20991887/18/20161/1/20991899/19/20161/1/209919010/31/20161/1/209919111/7/201610/4/202319211/28/20161/1/20991933/6/20171/1/20991943/6/20171/1/20991957/17/20171/1/20991969/29/20171/1/20991979/18/20171/1/20991987/15/20241/1/209919910/30/20171/1/20992004/4/20221/1/209920111/27/20171/1/209920211/13/20171/1/20992032/12/20181/1/20992043/26/20181/1/20992054/30/20181/1/20992064/30/20181/1/20992074/30/20181/1/20992086/1/20151/1/20992098/14/20151/1/209921010/13/20151/1/209921110/12/20151/1/209921211/17/20151/1/20992131/11/20165/23/202421410/12/20161/1/209921511/8/20161/1/209921612/12/20161/1/20992175/21/20171/1/20992188/21/20171/1/20992199/4/201712/16/202322010/16/20171/1/20992212/5/20181/1/20992224/10/20181/1/20992235/30/20181/1/20992247/2/20181/1/209922511/2/20151/1/209922611/30/20151/1/209922712/2/20151/1/20992284/11/20161/1/20992294/11/20161/1/20992308/29/20161/1/20992319/16/20161/1/20992323/28/20171/1/20992333/13/20171/1/20992343/13/20171/1/20992357/31/20231/1/20992364/24/20171/1/20992375/4/20171/1/20992386/25/20181/1/20992397/11/20181/1/20992407/23/20181/1/20992419/3/20181/1/20992429/10/20181/1/209924310/25/20181/1/209924410/25/20185/31/202424510/29/20181/1/209924611/5/20181/1/209924711/7/20181/1/209924811/12/20181/1/209924912/3/20181/1/209925012/17/201812/11/20232511/7/20191/1/20992525/25/20201/1/20992531/21/20191/1/20992543/11/20191/1/20992553/17/20191/1/20992563/25/20191/1/20992574/29/20191/1/20992585/28/20191/1/20992597/22/20191/1/20992608/19/20191/1/209926110/7/20191/1/209926210/7/20191/1/209926310/14/20191/1/209926410/23/20193/22/202426511/4/20191/1/209926611/11/20191/1/209926711/18/20191/1/209926810/13/20201/1/20992691/6/20201/1/20992701/20/20201/1/20992717/10/20231/1/20992727/9/20201/1/20992736/8/20201/1/20992746/22/20201/1/209927510/5/20201/1/209927610/5/20201/1/209927710/12/20201/1/209927810/26/20201/1/209927911/3/20201/1/209928012/21/20201/1/20992811/13/20211/1/20992821/4/20211/1/20992831/27/20211/1/20992841/25/20211/1/20992852/1/20211/1/20992862/1/20211/1/20992872/8/20211/1/20992884/5/20211/1/20992893/22/20211/1/20992905/3/20211/1/20992915/17/20211/1/20992925/3/20211/1/20992935/3/20211/1/20992945/3/20211/1/20992955/3/20211/1/20992965/17/20211/1/20992976/6/20221/1/20992985/17/20211/1/20992995/31/20211/1/20993006/7/202110/26/20233016/7/20211/1/20993026/28/20211/30/20243036/21/20211/1/20993047/19/20211/1/20993057/5/20211/1/20993067/5/20216/1/20243077/5/20211/1/20993087/27/20211/1/20993098/2/20211/1/2099

Forum Discussion

Static Measure-ALL() and Removefilters() not working

Attempted Solutions

6 Replies

Related content

Measure with ALL or REMOVEFILTER not working

DAX Measures ALL, REMOVEFILTERS

Removefilters not working

REMOVEFILTERS() not working as expected

RemoveFilters is not working

Tenure bucket	EEID	TenureMonth	TerminationDate	Hiredate
0-3 Months	1	3	3/22/2021	1/4/2021
0-3 Months	2	1	2/5/2021	1/11/2021
0-3 Months	3	1	7/6/2021	5/31/2021
0-3 Months	4	1	8/3/2021	7/12/2021
0-3 Months	5	2	11/23/2021	9/13/2021
0-3 Months	6	2	1/24/2022	11/15/2021
0-3 Months	7	1	3/9/2022	1/31/2022
0-3 Months	8	1	2/18/2022	1/24/2022
0-3 Months	9	0	4/26/2022	4/26/2022
0-3 Months	10	1	8/26/2022	8/8/2022
0-3 Months	11	2	11/4/2022	8/22/2022
0-3 Months	12	0	9/3/2022	8/29/2022
0-3 Months	13	3	4/30/2023	2/6/2023
0-3 Months	14	3	10/26/2023	7/31/2023
0-3 Months	15	2	12/22/2023	10/16/2023
0-3 Months	16	2	3/22/2024	2/5/2024
0-3 Months	17	0	2/22/2024	2/15/2024
3-6 Months	18	5	5/3/2021	11/30/2020
3-6 Months	19	3	4/9/2021	12/28/2020
3-6 Months	20	5	12/7/2021	6/28/2021
3-6 Months	21	5	4/1/2022	10/25/2021
3-6 Months	22	5	3/25/2022	11/1/2021
3-6 Months	23	6	8/8/2022	2/14/2022
3-6 Months	24	4	9/2/2022	5/2/2022
3-6 Months	25	6	2/21/2023	9/7/2022
3-6 Months	26	5	3/10/2023	10/10/2022
3-6 Months	27	6	6/30/2023	1/2/2023
3-6 Months	28	6	2/27/2024	9/11/2023
3-6 Months	29	5	5/15/2024	12/11/2023
6-9 Months	30	9	2/18/2022	6/7/2021
6-9 Months	31	7	2/14/2022	8/2/2021
6-9 Months	32	7	7/21/2021	1/4/2021
6-9 Months	33	7	6/13/2022	11/29/2021
6-9 Months	34	6	6/3/2022	11/29/2021
6-9 Months	35	6	10/17/2022	4/18/2022
6-9 Months	36	8	12/31/2022	5/9/2022
6-9 Months	37	8	2/28/2023	7/5/2022
6-9 Months	38	6	9/9/2023	3/6/2023
6-9 Months	39	9	12/30/2023	4/14/2023
6-9 Months	40	7	1/8/2024	6/26/2023
6-9 Months	41	7	3/21/2024	9/5/2023
6-9 Months	42	8	5/10/2024	9/5/2023
6-9 Months	43	7	7/2/2024	12/11/2023
6-9 Months	44	7	7/28/2024	1/9/2024
9-12 Months	45	10	6/25/2024	8/28/2023
9-12 Months	46	11	3/1/2022	4/12/2021
9-12 Months	47	11	10/25/2021	11/16/2020
9-12 Months	48	10	4/30/2021	6/24/2020
9-12 Months	49	11	2/4/2022	3/8/2021
9-12 Months	50	10	1/24/2022	4/12/2021
9-12 Months	51	12	4/15/2022	4/26/2021
9-12 Months	52	9	5/9/2022	8/2/2021
9-12 Months	53	12	8/19/2022	8/30/2021
9-12 Months	54	10	10/8/2022	11/29/2021
9-12 Months	55	10	11/2/2022	1/17/2022
9-12 Months	56	10	11/14/2022	1/17/2022
9-12 Months	57	10	5/2/2023	7/11/2022
9-12 Months	58	11	6/2/2023	7/18/2022
9-12 Months	59	9	6/30/2023	9/26/2022
9-12 Months	60	12	9/16/2023	9/26/2022
9-12 Months	61	11	10/13/2023	11/21/2022
9-12 Months	62	11	5/18/2024	6/26/2023
9-12 Months	63	11	7/19/2024	8/14/2023
12-18 Months	64	18	4/18/2022	10/29/2020
12-18 Months	65	17	4/19/2021	11/18/2019
12-18 Months	66	15	6/18/2021	3/23/2020
12-18 Months	67	17	11/23/2021	6/24/2020
12-18 Months	68	14	12/3/2021	10/5/2020
12-18 Months	69	12	10/29/2021	11/2/2020
12-18 Months	70	15	2/25/2022	12/14/2020
12-18 Months	71	16	5/13/2022	1/5/2021
12-18 Months	72	16	4/29/2022	1/4/2021
12-18 Months	73	14	7/29/2022	6/7/2021
12-18 Months	74	17	11/10/2022	6/7/2021
12-18 Months	75	16	10/11/2022	6/7/2021
12-18 Months	76	16	10/21/2022	6/21/2021
12-18 Months	77	12	6/10/2022	6/14/2021
12-18 Months	78	15	3/31/2023	1/10/2022
12-18 Months	79	13	3/31/2023	3/7/2022
12-18 Months	80	15	6/17/2023	3/16/2022
12-18 Months	81	13	7/14/2023	6/6/2022
12-18 Months	82	15	9/8/2023	6/13/2022
12-18 Months	83	14	10/7/2023	8/17/2022
12-18 Months	84	16	12/21/2023	8/22/2022
12-18 Months	85	17	2/14/2024	9/19/2022
12-18 Months	86	14	3/29/2024	2/6/2023
12-18 Months	87	13	5/18/2024	4/24/2023
12-18 Months	88	13	7/13/2024	6/12/2023
12-18 Months	89	13	8/2/2024	7/24/2023
18-24 Months	90	22	7/30/2021	10/7/2019
18-24 Months	91	20	6/11/2021	10/8/2019
18-24 Months	92	23	9/2/2022	10/5/2020
18-24 Months	93	20	1/13/2023	5/24/2021
18-24 Months	94	20	1/1/2023	5/24/2021
18-24 Months	95	22	3/21/2023	5/27/2021
18-24 Months	96	20	3/11/2023	7/5/2021
18-24 Months	97	23	8/18/2023	9/13/2021
18-24 Months	98	23	7/28/2023	8/23/2021
18-24 Months	99	18	2/25/2023	8/24/2021
18-24 Months	100	19	6/9/2023	11/18/2021
18-24 Months	101	21	9/1/2023	11/29/2021
18-24 Months	102	21	10/23/2023	1/17/2022
18-24 Months	103	21	9/29/2023	1/17/2022
18-24 Months	104	19	1/31/2024	7/11/2022
18-24 Months	105	20	3/15/2024	7/18/2022
18-24 Months	106	19	2/29/2024	7/25/2022
18-24 Months	107	20	3/19/2024	8/1/2022
18-24 Months	108	21	5/10/2024	8/8/2022
18-24 Months	109	21	6/5/2024	9/26/2022
24-30 Months	110	29	4/16/2021	12/12/2018
24-30 Months	111	26	1/5/2022	12/2/2019
24-30 Months	112	25	2/2/2022	1/20/2020
24-30 Months	113	29	9/30/2023	5/17/2021
24-30 Months	114	29	10/26/2023	6/7/2021
24-30 Months	115	26	3/15/2024	1/17/2022
24-30 Months	116	26	3/8/2024	1/17/2022
24-30 Months	117	26	7/10/2024	5/23/2022
24-30 Months	118	26	8/2/2024	6/29/2022
24-30 Months	119	25	7/31/2024	7/18/2022
30-36 Months	120	33	6/21/2024	9/22/2021
30-36 Months	121	33	4/8/2023	8/3/2020
30-36 Months	122	32	1/30/2024	6/28/2021
30-36 Months	123	35	6/1/2024	7/5/2021
30-36 Months	124	30	3/19/2024	9/20/2021
36-42 Months	125	42	11/24/2023	6/24/2020
36-42 Months	126	38	5/1/2021	3/5/2018
36-42 Months	127	36	10/7/2022	10/12/2019
36-42 Months	128	37	10/28/2022	10/12/2019
36-42 Months	129	37	10/28/2022	10/12/2019
36-42 Months	130	40	1/14/2023	10/12/2019
36-42 Months	131	37	10/28/2022	10/12/2019
42-48 Months	132	44	2/25/2022	7/2/2018
42-48 Months	133	47	7/19/2022	9/17/2018
42-48 Months	134	46	7/15/2022	10/8/2018
42-48 Months	135	45	8/12/2022	11/19/2018
48+ Months	136	409	9/30/2023	2/19/1990
48+ Months	137	359	7/1/2024	1/11/1995
48+ Months	138	286	1/28/2022	8/3/1998
48+ Months	139	186	1/3/2022	9/11/2006
48+ Months	140	152	3/8/2022	9/9/2009
48+ Months	141	150	3/8/2023	10/28/2010
48+ Months	142	54	6/17/2024	1/6/2020
48+ Months	143	147	9/30/2023	8/29/2011
48+ Months	144	146	8/18/2023	8/29/2011
48+ Months	145	134	10/1/2022	9/20/2011
48+ Months	146	117	5/28/2021	10/31/2011
48+ Months	147	126	3/21/2022	11/11/2011
48+ Months	148	120	1/6/2023	2/18/2013
48+ Months	149	118	11/11/2022	3/11/2013
48+ Months	150	101	7/9/2021	3/29/2013
48+ Months	151	101	8/2/2021	4/29/2013
48+ Months	152	113	8/12/2022	5/6/2013
48+ Months	153	111	7/1/2023	5/28/2014
48+ Months	154	123	7/1/2024	5/19/2014
48+ Months	155	94	5/26/2022	8/25/2014
48+ Months	156	99	12/30/2022	11/10/2014
48+ Months	157	74	4/27/2021	3/19/2015
48+ Months	158	73	6/5/2021	6/22/2015
48+ Months	159	74	9/29/2021	9/14/2015
48+ Months	160	76	8/14/2023	5/29/2017
48+ Months	161	121	11/8/2021	12/12/2011
48+ Months	162	105	1/3/2022	5/13/2013
48+ Months	163	81	12/31/2021	5/18/2015
48+ Months	164	323	2/1/2022	7/17/1995
48+ Months	165	233	2/14/2022	1/6/2003
48+ Months	166	216	10/3/2022	1/10/2005
48+ Months	167	195	10/3/2021	9/21/2005
48+ Months	168	218	4/27/2023	6/15/2005
48+ Months	169	412	4/1/2023	5/29/1989
48+ Months	170	198	6/17/2022	3/24/2006
48+ Months	171	184	9/30/2021	8/11/2006
48+ Months	172	381	6/1/2022	2/20/1991
48+ Months	173	309	1/31/2024	9/21/1998
48+ Months	174	311	4/30/2024	10/27/1998
48+ Months	175	349	4/1/2023	8/15/1994
48+ Months	176	329	9/25/2021	9/19/1994
48+ Months	177	74	10/29/2021	10/12/2015
48+ Months	178	79	5/18/2023	11/7/2016
48+ Months	179	84	10/4/2023	11/7/2016
48+ Months	180	62	5/11/2022	3/27/2017
48+ Months	181	62	5/26/2022	4/24/2017
48+ Months	182	60	9/2/2022	9/29/2017
48+ Months	183	102	5/23/2024	1/11/2016
48+ Months	184	48	5/1/2021	5/21/2017
48+ Months	185	74	6/9/2023	5/21/2017
48+ Months	186	76	12/16/2023	9/4/2017
48+ Months	187	84	5/27/2022	6/29/2015
48+ Months	188	81	4/19/2022	8/12/2015
48+ Months	189	94	8/4/2023	11/25/2015
48+ Months	190	57	7/16/2021	11/8/2016
48+ Months	191	62	8/29/2023	8/6/2018
48+ Months	192	68	5/31/2024	10/25/2018
48+ Months	193	61	12/11/2023	12/17/2018
48+ Months	194	57	9/8/2023	1/7/2019
48+ Months	195	54	6/2/2023	1/7/2019
48+ Months	196	54	3/22/2024	10/23/2019
48+ Months	197	57	6/14/2024	10/12/2019

EED	Hiredate	TerminationDate
1	8/18/2003	1/1/2099
2	9/8/2003	1/1/2099
3	9/8/2003	1/1/2099
4	10/20/1987	1/1/2099
5	1/2/2004	1/1/2099
6	4/7/1980	1/1/2099
7	5/17/1994	1/1/2099
8	10/2/1988	1/1/2099
9	9/14/1994	1/1/2099
10	2/28/2005	1/1/2099
11	1/10/1995	1/1/2099
12	1/11/1995	7/1/2024
13	3/1/2021	1/1/2099
14	7/7/1998	1/1/2099
15	2/14/2011	1/1/2099
16	1/29/1996	1/1/2099
17	4/24/2006	1/1/2099
18	5/27/1997	1/1/2099
19	7/10/2006	1/1/2099
20	10/1/2006	1/1/2099
21	1/12/2007	1/1/2099
22	3/26/2007	1/1/2099
23	3/20/1998	1/1/2099
24	4/3/2000	1/1/2099
25	2/4/1999	1/1/2099
26	10/9/2007	1/1/2099
27	11/2/2007	1/1/2099
28	6/7/2010	1/1/2099
29	7/5/2011	1/1/2099
30	11/26/2007	1/1/2099
31	9/20/1999	1/1/2099
32	1/2/2008	1/1/2099
33	1/11/2008	1/1/2099
34	5/8/2000	1/1/2099
35	9/2/2008	1/1/2099
36	9/9/2009	1/1/2099
37	9/22/2009	1/1/2099
38	5/1/2010	1/1/2099
39	3/19/2007	1/1/2099
40	10/2/2000	1/1/2099
41	11/5/2007	1/1/2099
42	1/8/2001	1/1/2099
43	4/2/2001	1/1/2099
44	11/9/2010	1/1/2099
45	1/7/2008	1/1/2099
46	11/5/2001	1/1/2099
47	11/5/2001	1/1/2099
48	1/6/2020	6/17/2024
49	5/16/2011	1/1/2099
50	5/23/2011	1/1/2099
51	7/1/2011	1/1/2099
52	7/11/2011	1/1/2099
53	6/29/2011	1/1/2099
54	7/11/2011	1/1/2099
55	10/31/2011	1/1/2099
56	10/31/2011	1/1/2099
57	11/7/2011	1/1/2099
58	1/30/2012	1/1/2099
59	1/30/2012	1/1/2099
60	2/6/2012	1/1/2099
61	2/4/2019	1/1/2099
62	9/17/2012	1/1/2099
63	1/14/2013	1/1/2099
64	1/14/2013	1/1/2099
65	2/18/2013	1/1/2099
66	3/25/2024	1/1/2099
67	6/3/2013	1/1/2099
68	9/16/2013	1/1/2099
69	9/13/2013	1/1/2099
70	10/14/2013	1/1/2099
71	10/29/2013	1/1/2099
72	12/9/2013	1/1/2099
73	1/1/2014	1/1/2099
74	1/6/2014	1/1/2099
75	1/6/2014	1/1/2099
76	1/20/2014	1/1/2099
77	1/20/2014	1/1/2099
78	1/21/2014	1/1/2099
79	2/3/2014	1/1/2099
80	2/17/2014	1/1/2099
81	4/21/2014	1/1/2099
82	3/24/2014	1/1/2099
83	3/31/2014	1/1/2099
84	6/24/2020	11/24/2023
85	5/12/2014	1/1/2099
86	7/8/2019	1/1/2099
87	5/19/2014	7/1/2024
88	6/2/2014	1/1/2099
89	6/16/2014	1/1/2099
90	7/14/2014	1/1/2099
91	9/3/2014	1/1/2099
92	8/25/2014	1/1/2099
93	8/21/2014	1/1/2099
94	7/1/2006	1/1/2099
95	3/10/2003	1/1/2099
96	10/20/2014	1/1/2099
97	1/5/2015	1/1/2099
98	4/27/2015	1/1/2099
99	7/27/2015	1/1/2099
100	6/1/2015	1/1/2099
101	6/15/2015	1/1/2099
102	7/6/2015	1/1/2099
103	8/3/2015	1/1/2099
104	8/3/2015	1/1/2099
105	9/22/2021	6/21/2024
106	11/2/2015	1/1/2099
107	11/2/2015	1/1/2099
108	2/8/2016	1/1/2099
109	2/22/2016	1/1/2099
110	2/22/2016	1/1/2099
111	6/20/2016	1/1/2099
112	7/11/2016	1/1/2099
113	8/1/2016	1/1/2099
114	8/28/2023	6/25/2024
115	12/21/2016	1/1/2099
116	2/6/2017	1/1/2099
117	3/20/2017	1/1/2099
118	4/24/2017	1/1/2099
119	9/11/2017	1/1/2099
120	10/23/2017	1/1/2099
121	10/16/2017	1/1/2099
122	10/30/2017	1/1/2099
123	11/13/2017	1/1/2099
124	1/29/2018	1/1/2099
125	3/5/2018	1/1/2099
126	5/7/2018	1/1/2099
127	11/29/2010	1/1/2099
128	8/8/2005	1/1/2099
129	10/12/2009	1/1/2099
130	3/15/2010	1/1/2099
131	5/17/2010	1/1/2099
132	7/5/2010	1/1/2099
133	1/3/2011	1/1/2099
134	3/21/2011	1/1/2099
135	4/18/2011	1/1/2099
136	4/25/2011	1/1/2099
137	11/8/2023	1/1/2099
138	7/4/2011	1/1/2099
139	10/10/2011	1/1/2099
140	12/19/2011	1/1/2099
141	10/17/2023	1/1/2099
142	11/5/2012	1/1/2099
143	11/5/2012	1/1/2099
144	12/3/2012	1/1/2099
145	6/13/2013	1/1/2099
146	11/11/2013	1/1/2099
147	12/30/2013	1/1/2099
148	8/22/2022	1/1/2099
149	1/27/2014	1/1/2099
150	4/28/2014	1/1/2099
151	10/6/2014	1/1/2099
152	10/20/2014	1/1/2099
153	1/19/2015	1/1/2099
154	2/9/2015	1/1/2099
155	4/13/2015	1/1/2099
156	4/20/2015	1/1/2099
157	11/25/2002	1/1/2099
158	5/29/2001	1/1/2099
159	4/1/2004	1/1/2099
160	4/26/2004	1/1/2099
161	12/7/2001	1/1/2099
162	1/7/2002	1/1/2099
163	2/1/1999	1/1/2099
164	2/25/2002	1/1/2099
165	1/31/2000	1/1/2099
166	10/1/2002	1/1/2099
167	2/28/2003	1/1/2099
168	10/11/2004	1/1/2099
169	4/24/2006	1/1/2099
170	5/1/2006	1/1/2099
171	6/1/2006	1/1/2099
172	2/15/1993	1/1/2099
173	9/21/2006	1/1/2099
174	11/1/2006	1/1/2099
175	10/25/2006	1/1/2099
176	5/15/2008	1/1/2099
177	10/13/2008	1/1/2099
178	11/3/2008	1/1/2099
179	9/19/2011	1/1/2099
180	2/1/2000	1/1/2099
181	6/22/1985	1/1/2099
182	9/21/1998	1/31/2024
183	10/27/1998	4/30/2024
184	9/14/2015	1/1/2099
185	9/21/2015	1/1/2099
186	11/12/2020	1/1/2099
187	11/2/2015	1/1/2099
188	7/18/2016	1/1/2099
189	9/19/2016	1/1/2099
190	10/31/2016	1/1/2099
191	11/7/2016	10/4/2023
192	11/28/2016	1/1/2099
193	3/6/2017	1/1/2099
194	3/6/2017	1/1/2099
195	7/17/2017	1/1/2099
196	9/29/2017	1/1/2099
197	9/18/2017	1/1/2099
198	7/15/2024	1/1/2099
199	10/30/2017	1/1/2099
200	4/4/2022	1/1/2099
201	11/27/2017	1/1/2099
202	11/13/2017	1/1/2099
203	2/12/2018	1/1/2099
204	3/26/2018	1/1/2099
205	4/30/2018	1/1/2099
206	4/30/2018	1/1/2099
207	4/30/2018	1/1/2099
208	6/1/2015	1/1/2099
209	8/14/2015	1/1/2099
210	10/13/2015	1/1/2099
211	10/12/2015	1/1/2099
212	11/17/2015	1/1/2099
213	1/11/2016	5/23/2024
214	10/12/2016	1/1/2099
215	11/8/2016	1/1/2099
216	12/12/2016	1/1/2099
217	5/21/2017	1/1/2099
218	8/21/2017	1/1/2099
219	9/4/2017	12/16/2023
220	10/16/2017	1/1/2099
221	2/5/2018	1/1/2099
222	4/10/2018	1/1/2099
223	5/30/2018	1/1/2099
224	7/2/2018	1/1/2099
225	11/2/2015	1/1/2099
226	11/30/2015	1/1/2099
227	12/2/2015	1/1/2099
228	4/11/2016	1/1/2099
229	4/11/2016	1/1/2099
230	8/29/2016	1/1/2099
231	9/16/2016	1/1/2099
232	3/28/2017	1/1/2099
233	3/13/2017	1/1/2099
234	3/13/2017	1/1/2099
235	7/31/2023	1/1/2099
236	4/24/2017	1/1/2099
237	5/4/2017	1/1/2099
238	6/25/2018	1/1/2099
239	7/11/2018	1/1/2099
240	7/23/2018	1/1/2099
241	9/3/2018	1/1/2099
242	9/10/2018	1/1/2099
243	10/25/2018	1/1/2099
244	10/25/2018	5/31/2024
245	10/29/2018	1/1/2099
246	11/5/2018	1/1/2099
247	11/7/2018	1/1/2099
248	11/12/2018	1/1/2099
249	12/3/2018	1/1/2099
250	12/17/2018	12/11/2023
251	1/7/2019	1/1/2099
252	5/25/2020	1/1/2099
253	1/21/2019	1/1/2099
254	3/11/2019	1/1/2099
255	3/17/2019	1/1/2099
256	3/25/2019	1/1/2099
257	4/29/2019	1/1/2099
258	5/28/2019	1/1/2099
259	7/22/2019	1/1/2099
260	8/19/2019	1/1/2099
261	10/7/2019	1/1/2099
262	10/7/2019	1/1/2099
263	10/14/2019	1/1/2099
264	10/23/2019	3/22/2024
265	11/4/2019	1/1/2099
266	11/11/2019	1/1/2099
267	11/18/2019	1/1/2099
268	10/13/2020	1/1/2099
269	1/6/2020	1/1/2099
270	1/20/2020	1/1/2099
271	7/10/2023	1/1/2099
272	7/9/2020	1/1/2099
273	6/8/2020	1/1/2099
274	6/22/2020	1/1/2099
275	10/5/2020	1/1/2099
276	10/5/2020	1/1/2099
277	10/12/2020	1/1/2099
278	10/26/2020	1/1/2099
279	11/3/2020	1/1/2099
280	12/21/2020	1/1/2099
281	1/13/2021	1/1/2099
282	1/4/2021	1/1/2099
283	1/27/2021	1/1/2099
284	1/25/2021	1/1/2099
285	2/1/2021	1/1/2099
286	2/1/2021	1/1/2099
287	2/8/2021	1/1/2099
288	4/5/2021	1/1/2099
289	3/22/2021	1/1/2099
290	5/3/2021	1/1/2099
291	5/17/2021	1/1/2099
292	5/3/2021	1/1/2099
293	5/3/2021	1/1/2099
294	5/3/2021	1/1/2099
295	5/3/2021	1/1/2099
296	5/17/2021	1/1/2099
297	6/6/2022	1/1/2099
298	5/17/2021	1/1/2099
299	5/31/2021	1/1/2099
300	6/7/2021	10/26/2023
301	6/7/2021	1/1/2099
302	6/28/2021	1/30/2024
303	6/21/2021	1/1/2099
304	7/19/2021	1/1/2099
305	7/5/2021	1/1/2099
306	7/5/2021	6/1/2024
307	7/5/2021	1/1/2099
308	7/27/2021	1/1/2099
309	8/2/2021	1/1/2099

310	8/9/2021	1/1/2099
311	9/7/2021	1/1/2099
312	8/16/2021	1/1/2099
313	8/30/2021	1/1/2099
314	9/27/2021	1/1/2099
315	9/20/2021	3/19/2024
316	10/4/2021	1/1/2099
317	10/4/2021	1/1/2099
318	10/5/2021	1/1/2099
319	11/9/2021	1/1/2099
320	11/22/2021	1/1/2099
321	11/8/2021	1/1/2099
322	11/15/2021	1/1/2099
323	11/29/2021	1/1/2099
324	12/13/2021	1/1/2099
325	12/20/2021	1/1/2099
326	1/17/2022	1/1/2099
327	1/3/2022	1/1/2099
328	1/17/2022	10/23/2023
329	1/27/2022	1/1/2099
330	1/17/2022	1/1/2099
331	1/10/2022	1/1/2099
332	1/17/2022	1/1/2099
333	1/17/2022	3/15/2024
334	1/17/2022	3/8/2024
335	1/24/2022	1/1/2099
336	1/24/2022	1/1/2099
337	2/7/2022	1/1/2099
338	2/21/2022	1/1/2099
339	3/2/2022	1/1/2099
340	4/4/2022	1/1/2099
341	3/21/2022	1/1/2099
342	5/2/2022	1/1/2099
343	4/18/2022	1/1/2099
344	4/25/2022	1/1/2099
345	5/4/2022	1/1/2099
346	4/26/2022	1/1/2099
347	4/26/2022	1/1/2099
348	5/2/2022	1/1/2099
349	5/23/2022	7/10/2024
350	5/9/2022	1/1/2099
351	5/12/2022	1/1/2099
352	6/9/2022	1/1/2099
353	7/5/2022	1/1/2099
354	7/5/2022	1/1/2099
355	6/27/2022	1/1/2099
356	6/20/2022	1/1/2099
357	6/20/2022	1/1/2099
358	6/29/2022	8/2/2024
359	7/11/2022	1/1/2099
360	7/11/2022	1/31/2024
361	8/1/2022	1/1/2099
362	7/18/2022	3/15/2024
363	8/17/2022	10/7/2023
364	7/18/2022	7/31/2024
365	7/25/2022	2/29/2024
366	8/1/2022	3/19/2024
367	7/24/2022	1/1/2099
368	8/12/2022	1/1/2099
369	8/5/2022	1/1/2099
370	8/8/2022	5/10/2024
371	8/22/2022	1/1/2099
372	8/15/2022	1/1/2099
373	9/6/2022	1/1/2099
374	8/22/2022	12/21/2023
375	8/29/2022	1/1/2099
376	9/19/2022	1/1/2099
377	9/6/2022	1/1/2099
378	9/5/2022	1/1/2099
379	9/19/2022	2/14/2024
380	9/19/2022	1/1/2099
381	9/26/2022	1/1/2099
382	9/26/2022	6/5/2024
383	10/3/2022	1/1/2099
384	10/3/2022	1/1/2099
385	10/3/2022	1/1/2099
386	10/4/2022	1/1/2099
387	10/3/2022	1/1/2099
388	10/10/2022	1/1/2099
389	10/17/2022	1/1/2099
390	11/8/2022	1/1/2099
391	11/7/2022	1/1/2099
392	1/9/2023	1/1/2099
393	11/21/2022	10/13/2023
394	11/28/2022	1/1/2099
395	1/2/2023	1/1/2099
396	12/19/2022	1/1/2099
397	12/23/2022	1/1/2099
398	1/3/2023	1/1/2099
399	1/9/2023	1/1/2099
400	1/5/2023	1/1/2099
401	1/9/2023	1/1/2099
402	2/6/2023	3/29/2024
403	2/6/2023	1/1/2099
404	2/6/2023	1/1/2099
405	4/3/2023	1/1/2099
406	4/24/2023	5/18/2024
407	4/14/2023	12/30/2023
408	5/1/2023	1/1/2099
409	6/12/2023	1/1/2099
410	5/22/2023	1/1/2099
411	6/19/2023	1/1/2099
412	6/26/2023	1/8/2024
413	6/26/2023	1/1/2099
414	6/12/2023	7/13/2024
415	6/21/2023	1/1/2099
416	6/26/2023	1/1/2099
417	6/26/2023	5/18/2024
418	6/30/2023	1/1/2099
419	7/10/2023	1/1/2099
420	7/5/2023	1/1/2099
421	7/10/2023	1/1/2099
422	7/3/2023	1/1/2099
423	7/12/2023	1/1/2099
424	7/10/2023	1/1/2099
425	7/18/2023	1/1/2099
426	7/24/2023	8/2/2024
427	7/31/2023	10/26/2023
428	7/31/2023	1/1/2099
429	8/21/2023	1/1/2099
430	7/31/2023	1/1/2099
431	8/14/2023	1/1/2099
432	8/14/2023	1/1/2099
433	8/14/2023	1/1/2099
434	8/7/2023	1/1/2099
435	8/7/2023	1/1/2099
436	8/14/2023	7/19/2024
437	8/28/2023	1/1/2099
438	9/5/2023	3/21/2024
439	9/5/2023	5/10/2024
440	9/11/2023	1/1/2099
441	9/5/2023	1/1/2099
442	9/11/2023	2/27/2024
443	9/18/2023	1/1/2099
444	9/14/2023	1/1/2099
445	9/21/2023	1/1/2099
446	9/21/2023	1/1/2099
447	9/21/2023	1/1/2099
448	9/21/2023	1/1/2099
449	9/21/2023	1/1/2099
450	10/3/2023	1/1/2099
451	10/9/2023	1/1/2099
452	10/16/2023	12/22/2023
453	11/14/2023	1/1/2099
454	10/31/2023	1/1/2099
455	11/1/2023	1/1/2099
456	11/6/2023	1/1/2099
457	11/6/2023	1/1/2099
458	11/7/2023	1/1/2099
459	11/28/2023	1/1/2099
460	11/6/2023	1/1/2099
461	11/27/2023	1/1/2099
462	11/14/2023	1/1/2099
463	12/4/2023	1/1/2099
464	12/4/2023	1/1/2099
465	12/4/2023	1/1/2099
466	12/11/2023	7/2/2024
467	12/5/2023	1/1/2099
468	12/11/2023	5/15/2024
469	12/19/2023	1/1/2099
470	1/16/2024	1/1/2099
471	1/2/2024	1/1/2099
472	1/2/2024	1/1/2099
473	1/1/2024	1/1/2099
474	1/9/2024	7/28/2024
475	1/1/2024	1/1/2099
476	1/8/2024	1/1/2099
477	1/15/2024	1/1/2099
478	1/9/2024	1/1/2099
479	1/16/2024	1/1/2099
480	1/15/2024	1/1/2099
481	1/17/2024	1/1/2099
482	2/5/2024	3/22/2024
483	2/7/2024	1/1/2099
484	3/11/2024	1/1/2099
485	3/18/2024	1/1/2099
486	4/1/2024	1/1/2099
487	4/1/2024	1/1/2099
488	4/15/2024	1/1/2099
489	4/22/2024	1/1/2099
490	4/22/2024	1/1/2099
491	5/6/2024	1/1/2099
492	5/1/2024	1/1/2099
493	5/1/2024	1/1/2099
494	5/1/2024	1/1/2099
495	5/1/2024	1/1/2099
496	5/6/2024	1/1/2099
497	6/17/2024	1/1/2099
498	5/10/2024	1/1/2099
499	6/13/2024	1/1/2099
500	6/12/2024	1/1/2099
501	6/19/2024	1/1/2099
502	6/24/2024	1/1/2099
503	7/9/2024	1/1/2099
504	7/15/2024	1/1/2099
505	8/5/2024	1/1/2099
506	7/29/2024	1/1/2099
507	8/5/2024	1/1/2099
508	7/29/2024	1/1/2099
509	8/5/2024	1/1/2099
510	10/12/2019	1/1/2099
511	10/12/2019	1/1/2099
512	10/12/2019	1/1/2099
513	10/12/2019	1/1/2099
514	10/12/2019	1/1/2099
515	10/12/2019	1/1/2099
516	7/24/2023	1/1/2099
517	10/12/2019	1/1/2099
518	10/12/2019	1/1/2099
519	10/12/2019	1/1/2099
520	10/12/2019	1/1/2099
521	10/12/2019	1/1/2099
522	10/12/2019	6/14/2024
523	10/12/2019	1/1/2099