Forum Discussion
Solved
USERELATIONSHIP Function to Align Dates
I have two datasets that I want to be able to filter with the same date filter - there is no clear link between the two datasets so after some research I discovered the USERELATIONSHIP Function might...
srennie , Try like
CALCULATE(CALCULATE(DISTINCTCOUNT(Defect_Data[Defect #]), FILTER(Defect_Data, Defect_Data[Supplier Defect] = "N")), USERELATIONSHIP('Calendar'[Date], Defect_Data[Creation Date]))
srennie , Try like
CALCULATE(CALCULATE(DISTINCTCOUNT(Defect_Data[Defect #]), FILTER(Defect_Data, Defect_Data[Supplier Defect] = "N")), USERELATIONSHIP('Calendar'[Date], Defect_Data[Creation Date]))
amitchandak That seems to have worked - thank you! Can you explain why you need to use the function this way?
