Distinct Count in PowerPivot v2 - MUCH Faster
User Rating: / 0
PoorBest 
Written by Rob Collie   
Thursday, 28 July 2011 19:14

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...

  Tags: v2, dax
 

Pyramid+PowerPivot