PowerBI Visual - Error

[Anonymous]

Hi People

I'm encountering this error while displaying my visual. Seems like error show only when I do select all.

Maybe my DAX measures are too much for system to handle it. Any other way to code the dax below? I'm using date intelligent for KPI.

Measure 1

TotalWOthismonth =

VAR Category = FILTER(swWorkProcFleet_Cat1,swWorkProcFleet_Cat1[Description] IN {"Critical Equipment","Schedule Maint","Survey","Shore Service"})

VAR MinDate = DATE(YEAR(Today()),1,1)

VAR TotalOverdue = CALCULATE([#Datecompleted],Category,

DATESBETWEEN('Calendar 1'[Date],MinDate,TODAY()-1))

VAR OverduePreviousMonths =

CALCULATE([#Datecompleted],Category,FILTER(swEqptHistory,[Current Month] = 0))

VAR firstDayMonth = DATE(Year(Today()), Month(Today()),1)

VAR TotalWOthismonth = CALCULATE([# Total WO],Category,

DATESBETWEEN('Calendar 1'[Date],firstDayMonth,Today()))

Return

TotalWOthismonth + OverduePreviousMonths

Measure 2 

% Critical Eqpt =

DIVIDE([#Critical No.],[TotalWOthismonth])

[v-diye-msft]

Hi @Anonymous 

As the info prompted in the tab header, "The query is too large, consider removing unused columns, add visual filters, or reducing the number of string type columns."

Please check Note of this article:If a table has too many values, consider converting it to a matrix and/or using drilldown. The maximum data points a table will display is 3,500.Here are some tips about Power BI performance for your reference.

I'd suggest creating views of the SQL Server tables used in the report. The views restricted the number of rows and columns considerably. We can used these views as the datasources for the report and it refreshes online without any issues.