help with optimizing DAX as visual exceeded available resources

[nic_k]

Running into an issue where "Visual exceeded available resources" if i don't filter the data for viewing.

All data is within a single table.

This how the table looks like when filtered by Name

Here is the DAX:

Duration From Previous Task = 
VAR _CurrentTaskTime =
    CALCULATE ( SELECTEDVALUE ( 'task'[Created On] ) )
VAR _PreviousTaskTime =
    CALCULATE (
        MAX (  'task'[Created On]  ),
        ALLEXCEPT ( 'task', 'task'[lead.fullname] ),
         'task'[Created On]  < _CurrentTaskTime
    )
VAR _timeDifference =
    IF (
        ISBLANK ( _PreviousTaskTime ),
        0,
        DATEDIFF ( _PreviousTaskTime, _CurrentTaskTime,DAY )
    )
RETURN
    _timeDifference

[some_bih]

Hi @nic_k the link below could help, I hope

https://blog.crossjoin.co.uk/2023/06/18/the-visual-has-exceeded-the-available-resources-error-in-pow...