Forum Discussion
Resources Exceeded Error when Creating a Profit and Loss Statement
Hi Everyone, I am creating a profit and loss statement using a switch function that helps map different measure results to the different P&L line items. A snippet of the measure is as below: ...
GilbertQ
Super User
Super UserHi Jason254
This happens when some of your measures consume a lot of memory. Typically it might be one measure causing this issue.
What I would do is to comment all of them out except 1. Then re-run your visual and see if it works.
Keep on uncommenting the measures in the switch statement until you get the above error.
When you get that error find a way to then change the way the DAX is written in the measure to not cause the error.