Slicers are damaging the cumulative line

[YavuzDuran]

Hi All

I have this chart showing a cumulative parameter 

with a measure : 

Charge Off % - Cumulative v2.0 = divide(calculate(sum(SalesDashboard[IsChargeOff]),filter(all(SalesDashboard[Loan Life (Month Period)]),SalesDashboard[Loan Life (Month Period)]<=max(SalesDashboard[Loan Life (Month Period)]))),calculate(countrows(SalesDashboard),allselected('SalesDashboard'[Loan Life (Month Period)])),0)

But whenever I play with one of those slicers, ie. Cash Down %

The graph does not seem to have a cumulative line

What might be the issue

please help

[v-yangliu-msft]

Hi  @YavuzDuran ,

You can change the all() inside to allselect().

Charge Off % - Cumulative v2.0 = divide(calculate(sum(SalesDashboard[IsChargeOff]),filter(allselected (SalesDashboard[Loan Life (Month Period)]),SalesDashboard[Loan Life (Month Period)]<=max(SalesDashboard[Loan Life (Month Period)]))),calculate(countrows(SalesDashboard),allselected('SalesDashboard'[Loan Life (Month Period)])),0)

If it does not meet your expected results, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[goncalogeraldes]

I would advise to use variables for the measure to parse through rather than the formula you have. For example:

Charge Off % - Cumulative v2.0 = 
var sales_charge_off = calculate(sum(SalesDashboard[IsChargeOff]),filter(all(SalesDashboard[Loan Life (Month Period)]),SalesDashboard[Loan Life (Month Period)]<=max(SalesDashboard[Loan Life (Month Period)])))

var count_rows = calculate(countrows(SalesDashboard),allselected('SalesDashboard'[Loan Life (Month Period)]))

return
divide(sales_charge_off,count_rows)

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes

[YavuzDuran]

Did not work

@goncalogeraldes