Performance of Cumulative Function

[Antmkjr]

https://drive.google.com/file/d/1C4cKXalkDq95yFt5BWdVwwoxL0oAiJ8U/view?usp=sharing 

In the attached pbix, I am trying to calculate Cumulative Final To Collect.

There are two issues

1) 

CALCULATE([Final To Collect]+[Total Project Collections],FILTER ( ALLSELECTED( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) ))

is giving incorrect results

2) The performance is bad if I use this for a large dataset

Expected result

Oct 2020   43.5 (=35+8.5)

Nov 2020  53.5  (= 43.5+10)

Dec 2020   63.5  (=53.5+10_

And so on...(Total project collections should be cumulated with Final To Collect)

[amitchandak]

@Antmkjr , Final To Collect is creating a problem. Try to avoid comparison or cumulative and normal measures. see if you can get that without cumulative 

 min(SUM('To Collect'[To Collect]), [Cumulative Net to Collect] )

There are quite a few cumulative  in report and then they used in another cumulative , causing the slowness

[Antmkjr]

@mahoneypat Similar issue to that of the yesterday's. But this time with another formula, could you please suggest how to improve performance