Forum Discussion
jaylyn
Helper I
Helper IStatic Measure-ALL() and Removefilters() not working
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 ra...
jaylynHelper I
Helper Isample data:
thank you!
| 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 |