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)  ...
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