thanks to team edna for such a great portal and the contents!
I built a pareto analysis, taking inspiration from enterprise DNA portal content, which provides a great insight into who our key customers are, however i could use some help in addressing the performance issues.
The report takes a really long time as it creates a virtual table for creating a cumulative sales for each customer, so wanted to know if others have faced this issue and if you any suggestion to overcome is much appreciated…
Cumulative sum measure that is causing performance issue is written as
CumulativeSales = var totalsales = CALCULATE(SUM(FactSales[AmountAvgUSD]),ALLSELECTED(FactSales)) var currentsales = SUM(FactSales[AmountAvgUSD]) var summarydata = SUMMARIZE(ALLSELECTED(FactSales),FactSales[CustomerKey],"Revenue",SUM(FactSales[AmountAvgUSD])) var cumulativesum = SUMX(FILTER(summarydata,[Revenue] >= currentsales),[Revenue]) Return (cumulativesum)
the table is laid out as below