Forum Discussion
Solved
Query has exceeded available resources
Hi all, I try to filter a table based on a field parameter value to show only the rows with margin below the selected value. The regular filter visual does not allow to use a field parameter b...
Thanks for your help both, unfortunately suggested solutions don't work but I found a way to fix it. I created a measure with a IF that returns 1 or 0 based on the parameter and a recalculated margin within a SUMX instead of using the precalculated margin field.
It works now, the new formula is more complex but for some reason uses less resources
Poojara_D12
Super User
Super UserHi MrBlueSky2
Please try using the below DAX:
IsBelowSelectedMargin =
IF(
MAX('Table'[Margin]) < SELECTEDVALUE('Field Parameter Table'[Field Parameter]),
1,
0
)
- Reduce table size in Power Query.
- Simplify DAX formulas.
- Ensure correct relationships between tables.