Visual exceeds available Resources with Blank Table Filter

[negbc]

I'm having an issue where the table visual data exceedes the available resources, so as a workaround I wanted to use the measure to keep the table blank until an option is selected by the filter (see below for code). However, I still get the available resources error when nothing is selected. Is there another solution I can try or is the only option to reduce the number of columns in the table?

Filtered Table =

CALCULATE(

    IF(ISFILTERED('Detail Report'[Contract #]), 1, 0), ALLSELECTED('Detail Report')

)

[PijushRoy · Accepted solution]

Hi @negbc 

If it is happening in Power BI Desktop file,
Can you please clear catch and try again
Please check if your C drive is full or not

If use the default slicer, for example, if you have  10 country of data in Matrix Visual. Create a Country filter and one Country as default. Just idea, so it will load faster and users can change silcer and see report.

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS 

Thanks
Pijush