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!
MrBlueSky2 That shoulds really odd. Any chance you can post the PBIX?
Cannot share the PBIX but found a solution, I rewrited the measure as (SUM(x)-SUM(y))/SUM(y) and it works now!