Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I am trying to get the running total id count per lead to contact days. I am failing miserably - any help wold be appreciated.
thanks
Vikash
Hi @vikash-jamnadas ,
Have you tried my suggestion? Can it solve your problem?
Best Regards,
Community Support Team _ kalyj
It's been a while. My guess is, change the >= LeadCnt to be <=LeadCnt
Hi @vikash-jamnadas ,
Try to modify the return part like this:
RETURN
CALCULATE (
[Total Leads],
FILTER (
ALL ( opportunity ),
[Lead to Contacted Days] <= MAX ( [Lead to Contacted Days] )
)
) / TotalLeadAllLead2Contact
Best Regards,
Community Support Team _ kalyj
If this post helps, then please considerAccept it as the solution to help the other members find it more quickly.
Hi @MattAllington ,
Thanks for this. Following is what I have done
I can see that this is working by sorting Total Lead count in desc order and calculating the cumulative based on that. However I want the cumulative based on opportunity[Lead to Contacted Days] in asc order. How will I have to adjust the formular to achive this?
Kind Regards
Vikash
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |