help with optimizing DAX as visual exceeded available resources

nic_k — Wed, 04 Oct 2023 06:35:46 GMT

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

Re: help with optimizing DAX as visual exceeded available resources

some_bih — Wed, 04 Oct 2023 10:17:09 GMT

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-power-bi-desktop/

topic Re: help with optimizing DAX as visual exceeded available resources in DAX Commands and Tips

help with optimizing DAX as visual exceeded available resources

Re: help with optimizing DAX as visual exceeded available resources