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
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