Forum Discussion
Need advise to improve performance
Hi Girts,
in the link I've provided you'll also find a reference to this article: https://exceleratorbi.com.au/calculated-columns-vs-measures-dax/ which looks very relevant to me: Rentability % is mooost likely a case for measures (think a about the subtotals in your visualisations).
Hi Girts,
For huge amount of records, I haven't found any effective solutions to improve calculation performance. Maybe you can try to summary them before get data to power bi.
AFAIK, current power bi not support create dynamic calculated column/table based on filter/slicer.So I'd like to suggest you use measures to instead.
In addition, please don't nested complex measures or write complex formula in condition functions.(e.g. sumx, countx...)
Optimizing DAX expressions involving multiple measures
Regards,
Xiaoxin Sheng
I have 2 measures -> Totalsales= sum(sales) , Totalpurchases = sum(purchases) ,I am calculating new measure profit = sales - purchases , will writing profit = sum(sales) - sum(purchases) or profit = Totalsales -Totalpurchases is efficient or both are same as dax while calculating measures it converts the measures referred inside a measure into text format and then it will calculate
Which among those 2 approaches will be good in terms of perfromance,
