Hoping someone can help, I've just worked out how to use the Userelationship function to allow me to link two tables multiple times. I have a data table that has several date columns = Enquiry Date, Lead Date, Conversion Date. I have linked all of these to my calendar with the Conversion date being the default and the other two being activated by a Userelationship, for example:
Enquiry Date = CALCULATE(COUNTA(Leads[EnquiryDate]),USERELATIONSHIP(Leads[EnquiryDate],'Work Calendar'[Date]))
My issue is that I also need to add a filter to this calculation and don't know how. For example an enquiry is considered a call without an Active Code, so normally I would have a measure filtering all rows without a code and calling them Enquiries:
How do I essentially combine these so I can get a measure that filters the rows by whether or not they have an active code, yet at the same time applies the Userelationship so that the show correctly in a table by months?