Forum Discussion
MrBlueSky2
1 year agoFrequent Visitor
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...
- 1 year ago
Cannot share the PBIX but found a solution, I rewrited the measure as (SUM(x)-SUM(y))/SUM(y) and it works now!