DAX Exceeds Available Resources

[JillHenninger]

Hi all

The DAX formula below causes the "Visual Has Exceeded Available Resources" error for my Matrix. It will run when filtered, but not unfiltered (and I need it to be unfiltered). There are 3376 entries with 6 Rows (image below). Seems simple enough but - no luck!

Any ideas? Thank you!

Time for Extract 2 =
IF (
    CALCULATE (
        SUM ( AnalyticsRequestForm[January] ),
        AnalyticsRequestForm[Project Year] = "2021"
    ) = 0,
    DIVIDE (
        CALCULATE (
            SUM ( AnalyticsRequestForm[October] ),
            AnalyticsRequestForm[Project Year] = "2020"
        )
            + CALCULATE (
                SUM ( AnalyticsRequestForm[November] ),
                AnalyticsRequestForm[Project Year] = "2020"
            )
            + CALCULATE (
                SUM ( AnalyticsRequestForm[December] ),
                AnalyticsRequestForm[Project Year] = "2020"
            )
            + CALCULATE (
                SUM ( AnalyticsRequestForm[January] ),
                AnalyticsRequestForm[Project Year] = "2021"
            ),
        4
    ),
    CALCULATE (
        SUM ( AnalyticsRequestForm[January] ),
        AnalyticsRequestForm[Project Year] = "2021"
    )
)

 Layout

[amitchandak]

@JillHenninger , refer if this blog can help

https://blog.crossjoin.co.uk/2020/01/20/visual-has-exceeded-the-available-resources-error-power-bi/

Can you a sample pbix after removing sensitive data.