Forum Discussion
(Yet another) “Visual Has Exceeded The Available Resources” Error
Hi iW1DOV ,
Thank you for the update.
Since both the visual filter and the “visible measure” method still result in the resource exceeded error, this shows that the problem isn’t with the filter itself. The engine is processing the KPI at a highly detailed level, which leads to a large intermediate result and exceeds available memory, even with a basic condition like > 0.01.
To prevent this row-level recalculation, the most effective workaround is to move the threshold logic outside of the measure.
Recommended Options
- Create a Visibility Flag in the model
Add a column upstream (Power Query/Dataflow) like:
VisibilityFlag = if [KPI] < 0.01 then 0 else 1
Then, filter the visual using this flag to avoid costly measure-based filtering. - Pre-round the KPI column
If near-zero floating values aren't significant, round them during data preparation. This prevents unrounded values from causing heavy computations when filtering. - Check measure complexity
If the KPI uses iterators (SUMX/FILTER on large tables), consider moving some calculations into the model or using pre-aggregated tables to lower memory usage.
If you can provide a simplified version of the KPI measure, we can help identify what’s causing the resource usage and suggest a more efficient version.
Thank you.
- Create a Visibility Flag in the model
Uhm... it doesn't seem to be working. As soon as I add the "KPI Visible" measure to the grid, it crashes with the resource error, without even giving a chance to filter. And I removed the original measure first.
In my experience adding a visual level filters on a "Measure" can cause this kind of errors
can you write your actual measure result like this
KPI Visible =
IF( [KPI] > 0.1, [KPI])this does not have a non blank result and it should remove the records less than 0.1.
Please do note, if you have any other measure in the table visual then you need to add this kind of condition for them as well, other wise adding this condition to only one measure will simply put a blank value if the measure value is less then 0.1.
Lets say you have another measure called KPI2 then after adding the condition to KPI, add this condition to KPI 2 as well like:
KPI 2 visible = if([KPI] > 0.1, [KPI 2])
Connect on LinkedIn
|