Forum Discussion
Solved
Data Being Miscounted Because Calendar Table is Getting Filtered
Hi All, I have a calendar table connected to my projects table. Each project has multiple interviews so I have an interviews table connected to my projects table. We record about 10 times more inter...
I believe I found the answer in the USERELATIONSHIP DAX function. I created an inactive relationship between the Interviews[Date] and the Calendar[Date] and made a separate measure that uses USERELATIONSHIP. The data matches my pivot table checks.
I believe I found the answer in the USERELATIONSHIP DAX function. I created an inactive relationship between the Interviews[Date] and the Calendar[Date] and made a separate measure that uses USERELATIONSHIP. The data matches my pivot table checks.