Performance Issue with COUNTROWS Summarize

gardas_swathi Try this:

Product Coverage :=
VAR DemandProductIDColumn =
    VALUES ( 'Demand Table'[Product ID] )
VAR NewColumns =
    ADDCOLUMNS (
        DemandProductIDColumn,
        "@Demand", [Demand],
        "@MonthlySupply", [MonthlySupply],
        "@NetAvailSupplyDemand", [NetAvailSupplyDemand]
    )
VAR FilterRows =
    FILTER (
        NewColumns,
        VAR Demand_True_LessThanZero =
            ISBLANK ( [@Demand] ) = TRUE
                || [@Demand] <= 0
        VAR MonthlySupply_True_LessThanZero =
            ISBLANK ( [@MonthlySupply] ) = TRUE
                || [@MonthlySupply] <= 0
        VAR NetAvailSupplyDemand_True_LessThanZero =
            ISBLANK ( [@NetAvailSupplyDemand] ) = TRUE
                || [@NetAvailSupplyDemand] <= 0
        VAR Demand_FalseNotZero =
            ISBLANK ( [Demand] ) = FALSE
                || [Demand] > 0
        VAR MonthlySupply_True_Zero =
            ISBLANK ( [@MonthlySupply] ) = TRUE
                || [@MonthlySupply] = 0
        VAR Result =
            IF (
                OR (
                    Demand_True_LessThanZero && MonthlySupply_True_LessThanZero
                        && NetAvailSupplyDemand_True_LessThanZero,
                    Demand_True_LessThanZero
                        && [@MonthlySupply] > 0
                ),
                -1,
                IF (
                    Demand_FalseNotZero && MonthlySupply_True_Zero,
                    -1,
                    [@NetAvailSupplyDemand]
                )
            )
        RETURN
            Result > 0
    )
VAR RowCount =
    COUNTROWS ( FilterRows )
VAR Result =
    IF ( ISBLANK ( RowCount ) = TRUE && [NetAvailSupplyDemand] <= 0, 0, RowCount )
RETURN
    Result