Query exceeds available resources when adding [Measure] - 1

[MrBlueSky2]

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-intuitive as I'm just substracting a scalar value to the measure, so not complex calculation. Any help please?

The measure is in the form of SUM(x)/SUM(y) - 1

Best regards

[Anonymous]

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.

[Greg_Deckler]

@MrBlueSky2 That shoulds really odd. Any chance you can post the PBIX?

[MrBlueSky2 · Accepted solution]

Cannot share the PBIX but found a solution, I rewrited the measure as (SUM(x)-SUM(y))/SUM(y) and it works now!