Forum Discussion
Solved
USERELATIONSHIP is not working.
Hello, I am looking to calculate the percentage of on-time audits and plot them by their due date. The default relationship between the date table and the audit table uses the audit end date. When...
I found the solution. I need to move the variable definition within my final calculate statement. Otherwise, the variables are calculated outside of the filter context created by the USERELATIONSHIP statement.
RADACAD has a good article explaining it further: https://radacad.com/caution-when-using-variables-in-dax-and-power-bi
| 176 | Closed - Complete | 3/19/2019 | 3/18/2019 | 3/18/2019 |
| 177 | Closed - Complete | 3/20/2019 | 3/19/2019 | 3/5/2019 |
| 178 | Closed - Complete | 2/28/2019 | 2/28/2019 | 2/26/2019 |
| 179 | Closed - Complete | 1/11/2019 | 1/9/2019 | 12/20/2018 |
| 180 | Closed - Complete | 1/4/2019 | 1/4/2019 | 1/2/2019 |
| 181 | Closed - Complete | 2/28/2019 | 2/27/2019 | 2/21/2019 |
| 182 | Closed - Complete | 1/17/2019 | 1/17/2019 | 1/16/2019 |
| 183 | Closed - Complete | 3/18/2019 | 3/7/2019 | 2/26/2019 |
| 184 | Closed - Complete | 2/14/2019 | 1/16/2019 | 1/14/2019 |
| 185 | Closed - Complete | 4/19/2019 | 3/1/2019 | 2/27/2019 |
| 186 | Closed - Complete | 2/5/2019 | 2/4/2019 | 2/1/2019 |
| 187 | Closed - Complete | 2/7/2019 | 2/6/2019 | 2/5/2019 |
| 188 | Closed - Complete | 2/5/2019 | 2/4/2019 | 2/1/2019 |
| 189 | Closed - Complete | 2/21/2019 | 2/20/2019 | 2/12/2019 |
| 190 | Closed - Complete | 4/29/2019 | 3/21/2019 | 3/19/2019 |
| 191 | Closed - Complete | 2/15/2019 | 1/23/2019 | 1/22/2019 |
| 192 | Closed - Complete | 4/12/2019 | 3/14/2019 | 2/25/2019 |
| 193 | Closed - Complete | 4/17/2019 | 3/27/2019 | 3/26/2019 |
| 194 | Closed - Complete | 3/12/2019 | 2/25/2019 | 2/25/2019 |
| 195 | Closed - Complete | 3/12/2019 | 3/1/2019 | 3/1/2019 |
| 196 | Closed - Complete | 3/12/2019 | 3/7/2019 | 3/7/2019 |
| 197 | Closed - Complete | 2/18/2019 | 1/22/2019 | 1/21/2019 |
| 198 | Closed - Complete | 3/11/2019 | 3/8/2019 | 3/8/2019 |
| 199 | Closed - Complete | 3/22/2019 | 2/28/2019 | 2/28/2019 |
| 200 | Closed - Complete | 3/11/2019 | 2/18/2019 | 2/18/2019 |
| 201 | Closed - Complete | 3/12/2019 | 3/12/2019 | 3/12/2019 |
| 202 | Closed - Complete | 3/26/2019 | 2/26/2019 | 2/26/2019 |
| 203 | Closed - Complete | 3/26/2019 | 3/7/2019 | 2/27/2019 |
| 204 | Closed - Complete | 3/8/2019 | 2/11/2019 | 1/16/2019 |
| 205 | Closed - Complete | 3/20/2019 | 2/28/2019 | 2/26/2019 |
| 206 | Closed - Complete | 1/9/2019 | 1/8/2019 | 10/8/2018 |
| 207 | Closed - Complete | 2/22/2019 | 1/30/2019 | 1/29/2019 |
| 208 | Closed - Complete | 3/28/2019 | 3/20/2019 | 3/20/2019 |
| 209 | Closed - Complete | 3/6/2019 | 2/8/2019 | 2/8/2019 |
| 210 | Closed - Complete | 1/4/2019 | 1/4/2019 | 1/4/2019 |
| 211 | Closed - Complete | 3/11/2019 | 2/14/2019 | 2/13/2019 |
| 212 | Closed - Complete | 1/14/2019 | 1/14/2019 | 1/14/2019 |
| 213 | Closed - Complete | 2/20/2019 | 1/28/2019 | 12/10/2018 |
| 214 | Closed - Complete | 3/11/2019 | 2/14/2019 | 2/13/2019 |
| 215 | Closed - Complete | 3/7/2019 | 2/14/2019 | 2/13/2019 |
| 216 | Closed - Complete | 3/7/2019 | 2/14/2019 | 2/13/2019 |
| 217 | Closed - Complete | 4/16/2019 | 2/22/2019 | 2/20/2019 |
| 218 | Closed - Complete | 4/4/2019 | 3/14/2019 | 3/12/2019 |
| 219 | Closed - Complete | 7/26/2019 | 3/14/2019 | 3/13/2019 |
| 220 | Closed - Complete | 3/11/2019 | 2/25/2019 | 2/25/2019 |
| 221 | Closed - Complete | 3/22/2019 | 3/8/2019 | 3/4/2019 |
| 222 | Closed - Complete | 5/30/2019 | 3/7/2019 | 3/7/2019 |
| 223 | Closed - Complete | 5/7/2019 | 2/7/2019 | 2/5/2019 |
| 224 | Closed - Complete | 2/14/2019 | 1/24/2019 | 1/22/2019 |
| 225 | Closed - Complete | 2/20/2019 | 1/18/2019 | 1/16/2019 |
| 226 | Closed - Complete | 2/15/2019 | 1/18/2019 | 1/16/2019 |
| 227 | Closed - Complete | 3/11/2019 | 2/22/2019 | 2/22/2019 |
| 228 | Closed - Complete | 6/6/2019 | 2/7/2019 | 2/5/2019 |
| 229 | Closed - Complete | 4/15/2019 | 3/21/2019 | 3/19/2019 |
| 230 | Closed - Complete | 4/22/2019 | 3/29/2019 | 3/27/2019 |
| 231 | Closed - Complete | 2/18/2019 | 2/18/2019 | 2/18/2019 |
| 232 | Closed - Complete | 2/26/2019 | 2/26/2019 | 2/26/2019 |
| 233 | Closed - Complete | 1/17/2019 | 1/17/2019 | 1/17/2019 |
| 234 | Closed - Complete | 4/16/2019 | 3/15/2019 | 3/14/2019 |
| 235 | Closed - Complete | 3/29/2019 | 3/22/2019 | 3/21/2019 |
| 236 | Closed - Complete | 2/18/2019 | 2/18/2019 | 2/18/2019 |
| 237 | Closed - Complete | 1/15/2019 | 1/11/2019 | 1/4/2019 |
| 238 | Closed - Complete | 1/15/2019 | 1/15/2019 | 1/7/2019 |
| 239 | Closed - Complete | 3/26/2019 | 3/13/2019 | 3/12/2019 |
| 240 | Closed - Complete | 3/8/2019 | 2/6/2019 | 2/5/2019 |
| 241 | Closed - Complete | 3/11/2019 | 3/11/2019 | 3/11/2019 |
| 242 | Closed - Complete | 3/29/2019 | 3/15/2019 | 3/14/2019 |
| 243 | Closed - Complete | 4/4/2019 | 3/20/2019 | 3/19/2019 |
| 244 | Closed - Complete | 1/22/2019 | 1/22/2019 | 11/14/2018 |
| 245 | Closed - Complete | 3/15/2019 | 3/14/2019 | 3/7/2019 |
| 246 | Closed - Complete | 3/26/2019 | 3/20/2019 | 3/12/2019 |
| 247 | Closed - Complete | 2/4/2019 | 2/4/2019 | 2/4/2019 |
| 248 | Closed - Complete | 2/5/2019 | 2/5/2019 | 2/5/2019 |
| 249 | Closed - Complete | 2/5/2019 | 2/5/2019 | 2/5/2019 |
| 250 | Closed - Complete | 4/4/2019 | 3/28/2019 | 3/26/2019 |
| 251 | Closed - Complete | 3/4/2019 | 2/28/2019 | 2/27/2019 |
| 252 | Closed - Complete | 2/15/2019 | 2/14/2019 | 2/12/2019 |
| 253 | Closed - Complete | 3/12/2019 | 3/10/2019 | 3/9/2019 |
| 254 | Closed - Complete | 5/1/2019 | 2/18/2019 | 2/18/2019 |
| 255 | Closed - Complete | 2/13/2020 | 3/26/2019 | 1/21/2019 |
| 256 | Closed - Complete | 3/12/2019 | 3/11/2019 | 3/7/2019 |
Hi,
I do not understand your requirement at all. On a smaller dataset, could you show the expected result in a simple Table format.