Distinct Count in PowerPivot v2 - MUCH Faster
A quick update, as tonight I managed to sit down and experiment a bit with the V2 Beta for the first time in many days.
(OK, actually, I am standing up. because I have a fantastic new treadmill desk and have walked nearly 8 miles today while working, but that's a topic for another post).
I was working with one of our HostedPowerPivot clients today who was observing slower-than-expected slicer click performance in one of their reports. And after some sleuthing, I found that they had a "distinct count" measure in their model, something like this:
Read more...