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).
Short additional info ...
My task becomes more complex as I need to add KPI to report, same time keeping journal entry values to drill down.
For example:
- A Turnover
- B Direct costs
- C Bruto profit = A - B
- D Bruto profit rentability in % C/A
- ... etc
Same time need to keep sums for the whole company and by costs centers as well (projects, departments).
I tried to get it in one table, but I got more than 30 modifications. Now I am trying to split results in separate tables to unite them in one report.
Community ChampionHi 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).