Forum Discussion
Dax(measure) optimization
Hello All, Pleasew help me to optimize this DAX query. and please give me suggestion that can we change in into the column or not?? Target_Instance_type =
VAR _cpu = 'Aggregated by VM'[cpu_...
Hi madhavan2427 ,
Looking at the dax formula you provided, it seems that there is no particularly complicated calculation logic. Since you can’t know your data model, i can’t provide an optimized dax formula.
I suggest that you can view the following official website documents to optimize your data model and be familiar with the conversion between measure and calculated column.
Power BI Calculated Column vs Measure: A Comparison | Enterprise DNA
DAX Best Practices For Power BI | MAQ Software
In addition, you can use Performance Analyzer to check the formula query time to make improvements:
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.