Forum Discussion

MrBlueSky2's avatar
MrBlueSky2
Frequent Visitor
1 year ago
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...
  • MrBlueSky2's avatar
    MrBlueSky2
    1 year ago

    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

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

MrBlueSky2 

Create a Measure:

FilterMeasure = 
IF(
SELECTEDVALUE('YourFieldParameterTable'[FieldParameter]) > 0 &&
MAX('YourTable'[Margin]) < SELECTEDVALUE('YourFieldParameterTable'[FieldParameter]),
1,
0
)

Add this measure to your visual and set the filter to FilterMeasure = 1

If performance issues persist, simplify your data model or reduce the visual complexity by pre-aggregating data.

 

💡 If this helped, please give Kudos 👍 or mark it as a Solution ✅.
Best regards,
Kedar
🌐 Connect on LinkedIn