Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Performance of Cumulative Function

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)

 

 

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , 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