Forum Discussion
Solved
Query exceeds available resources when adding [Measure] - 1
Hi all, I have a measure that works well when adding it standalone to a visual, however when I do [Measure] - 1, it triggers a "query exceeds available resources" error. This is counter-intuit...
Cannot share the PBIX but found a solution, I rewrited the measure as (SUM(x)-SUM(y))/SUM(y) and it works now!
Hi,Greg_Deckler ,thanks for your concern about this issue.
Hello,MrBlueSky2 . I am glad to help you.
The problem you're experiencing does seem a bit strange, I'm guessing it might have something to do with the complexity of the middle step of the calculation process? But in fact both of your calculation logic are not complicated, maybe it has something to do with the data source data itself.
And It's great to see that you have shared your solution, you can mark your reply as a solution which can help other users.