Forum Discussion
Alternate solution to DAX
Hi All, I have written a dax function as shown below. It works completely fine and give solution I require, the only problem is it take too much time to execute which decreases the performance ...
Hi shrimankabra ,
According to your formula, it seems like you invoke many related tables as filter conditions.
When formula calculated on visuals, it will loop calculation on each row contents and affect performance.
Optimizing DAX expressions involving multiple measures
Optimizing nested iterators in DAX
You can consider to add a ranking column to data table instead cache these calculation in measure variables.
Regards,
XIaoxin Sheng
Hi,
Thanks for the suggestion, but there's a problem with it, adding ranks to column would make it static and won't change dynamically when I apply slicer filters to it.