Cumulative Total of id count per lead days

[vikash-jamnadas]

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

[v-yanjiang-msft]

Hi @vikash-jamnadas ,

Have you tried my suggestion? Can it solve your problem?

Best Regards,
Community Support Team _ kalyj

[MattAllington]

It's been a while.  My guess is, change the >= LeadCnt to be <=LeadCnt

[vikash-jamnadas]

@MattAllington  I'm afraid this does not work. 

[v-yanjiang-msft]

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.

[MattAllington]

Read my article here https://exceleratorbi.com.au/pareto-analysis-in-power-bi/

[vikash-jamnadas]

Hi @MattAllington ,

Thanks for this.  Following is what I have done 

Cumulative % =

VAR LeadCnt = opportunity[Total Leads] /* this sets the margin for the current product

(the one that is the current column in the column chart) */

VAR TotalLeadAllLead2Contact =

CALCULATE([Total Leads], ALL(opportunity[Lead to Contacted Days])) /* the total margin across all products.

This is needed to turn the absolute margin into a percentage */

RETURN

CALCULATE(

[Total Leads],

FILTER( ALL(opportunity[Lead to Contacted Days]), [Total Leads] >= LeadCnt)

) / TotalLeadAllLead2Contact

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