Forum Discussion
Optimizing DAX
Dear Community, I have the below DAX that it is slow : couldn't load the data for this visual - out of memory The goal for the dax is to show the SRU_DESCL_EN for the Supplier ERP having the ...
Hi! It is likely the ALL function taht you are using with CALCULATE. Do you need the measure to ignore page, report, and visual level filtering? If you do not need this measure to ignore any filtering you or the user applied to the report, then ALL is not needed and you can improve the performance by removing.
Hello audreygerred , thank you for your reply, yes All function is to remove effect of external slicers/ filters
Unfortunately, using ALL will cause performance decline.