Forum Discussion
id013
5 years agoHelper V
Visual is loading very slowly
Hi, I have a 2 cumulative count visuals, one that shows the cumulative count of units sold by date and the other the cumulative count of unique customers by date. I have a measure that calculates...
- 5 years ago
Ok I was able to fix my issue by changing my distinct count measure to use a combination of count rows, summarize & filter instead. The counts seems be correct (at least they match what they did with distinct count) and the performance improvement is the same as when I switched it out to just a count, 23000 milliseconds to just shy of 4000 milliseconds.
id013
5 years agoHelper V
Ok I was able to fix my issue by changing my distinct count measure to use a combination of count rows, summarize & filter instead. The counts seems be correct (at least they match what they did with distinct count) and the performance improvement is the same as when I switched it out to just a count, 23000 milliseconds to just shy of 4000 milliseconds.