Forum Discussion
Userelationship and Measures
- 8 years ago
Ok I've had some success, looked at it from a different angle and did it in two steps. Started with the measure that links the relationship so it will appear correctly in the month table:
Enquiry Date = CALCULATE(COUNTA(Leads[EnquiryDate]),USERELATIONSHIP(Leads[EnquiryDate],'Work Calendar'[Date]))
Then used this measure in the calculate to only look at calls without an approval date, rather than using the measure All Calls.
Enquiries = CALCULATE([Enquiry Date], Leads[DateActiveReferralCodeReceivedByOfficer] = BLANK())
This way I get the benefit of both calculations in the final measure. Maybe not what is considered elegant programing but it works which is the most important thing for me at the moment.
Thanks everyone for your input.
his came up with a blank result. That's ok, I'll go with my two step approach, appreciate the help.