cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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.

AnuTomy_1-1603703118283.png

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 2
Highlighted
Helper I
Helper I

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

Highlighted
Super User IV
Super User IV

@AnuTomy , 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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors