Forum Discussion
Power BI Desktop | DAX Tuning
I have the below DAX expression which is very slow during run time. I need in optimising and re-writting the DAX frmula so that it does not create much impact on FE and SE in Dax studio. DEFINE ...
lbendlin
Super User
Super UserVery easy - eliminate all the columns you don't need as well as all the measures you don't need. 🙂
In DAX Studio you can expand measures to see the underlying code. That will show you which of the measures is to blame. Or you can remove all measures, and then add them back in one by one while watching the timing.
What's the cardinality of your dimension tables? What other tables sit behind them?