In the attached pbix, I am trying to calculate Cumulative Final To Collect.
There are two issues
@mahoneypat Similar issue to that of the yesterday's. But this time with another formula, could you please suggest how to improve performance
@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
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.