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.
You can pass as many filters to calculate as you need. Just delete the last bracket in your first formula, then add your leads filter there
- eburke8 years agoHelper II
Hi Matt, thanks for the answer, unfortunately this gets me a result saying 'False' instead of the number of enquiries per month. Any idea where I'm going wrong here?