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

* 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 

* In this example, 13.2% is what i should get

---------------------------

terms_last_12months (new) =

VAR currentdate = MAX('Date'[Date])

VAR end_of_current_month = EOMONTH(currentdate, 0)  

VAR tweleve_month_ago_start = EOMONTH(end_of_current_month, -12) + 1

RETURN

CALCULATE(

    DISTINCTCOUNT(Employee[EEID]),

 Employee[TerminationDate] >= tweleve_month_ago_start &&

   Employee[TerminationDate] <= end_of_current_month

)

0-3Months

terms last 12M = 4

avg hc last 12 months = 470

turnover = 4/470 = 0.851%

3-6Months

terms last 12M = 2

avg hc last 12 months = 470

turnover = 2/470 = 0.4255%

6-9Months

terms last 12M = 7

avg hc last 12 months = 470

turnover = 7/470 = 1.489%

9-12Months

terms last 12M = 5

avg hc last 12 months = 470

turnover = 5/470 =1.0638%

12-18Months

terms last 12M = 8

avg hc last 12 months = 470

turnover = 8/470 =1.702%

18-24Months

terms last 12M = 9

avg hc last 12 months = 470

turnover = 9/470 = 1.915%

24-30Months

terms last 12M = 7

avg hc last 12 months = 470

turnover = 7/470 = 1.489%

30-36Months

terms last 12M = 4

avg hc last 12 months = 470

turnover = 4/470 = 0.851%

36-42Months

terms last 12M = 1

avg hc last 12 months = 470

turnover = 1/470 = 0.213%

48+Months

terms last 12 months = 15

avg hc last 12 months = 470

turnover = 15/470 = 3.19%

avg hc last 12M = 470

term last 12 M = 62

turnover = 62/470 =13.2%

turnover % = 13.2%