|Distinct Count in PowerPivot v2 - MUCH Faster|
|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...
- Schrodinger s Pivot, or Why CALCULATE() Should Be Your Favorite Function EVER.
- Repeat Customers in DAX: Three Flavors
- Displaying Top N, Bottom N, and "All Others"
- Blending "Time of Day" Analysis with Calendar/Date Analysis
- SUMX of IF: A Perfect Blend of Simple and Sophisticated
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- List of suggested datasets to test PowerPivot
- Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)
- DAX cheat sheet
- Learning PowerPivot and DAX
- Using Power Pivot and Power View for Profit Analysis