Dynamic report extremely slow - debug DAX request

Hi @dillenbram

Its really interesting. The issue is clear here Measures using iterator function(Filter)

Matrix is taking more than 3 mins to load… definitely we’ve to improve the performance.

If we can create a calculated column for Days Left…Instead of Iterator we can use direct filter I think this is not possible, because this is depending on selected date from slicer.

We’ve to think different approach. Let us know if you got any idea.