I rarely use ALLSELECTED(). Last time I did, I had to go look at the MSDN docs, never a good sign. But I have to say, unlike some of the docs… this one seems both accurate and understandable! I decided to play with it a bit today; here are the measures I tested with: Total Intensity:=SUM(Colors[Intensity])Total Intensity, ALL Level:=CALCULATE([Total Intensity], ALL(Colors[Level]))Total Intensity - ALLSELECTED Level:=CALCULATE([Total Intensity], ALLSELECTED(Colors[Level])) And here Continue Reading
DAX Table Query Example
As I referenced in my previous blog entry, we should take a look at DAX Table Queries. In the world I live in, which is really focused on Power Pivot, you really don’t see these queries too often. It probably doesn’t help that it’s a rather “hidden” feature in Excel. I get the feeling it is more common to write these queries when doing work against a Tabular server, but that’s typically isn’t my space. Still, I think there are some interesting reasons to use them in Excel… if nothing else Continue Reading
Power Pivot Performance Gotchas
One of my more common consults is for “my workbook is slow”. Occasionally, I will have to dig into the actual measures, but more typically, I just check for a few common issues that can have a large negative impact on performance. Before we dig into those, let’s just take one moment to state the obvious. Power Pivot is an in-memory database. Almost by definition… if you want things to run faster… use less memory! When I am looking at the customers model, the overriding question I am asking Continue Reading
My Wish List for Excel 2015
This certainly isn’t a list of suggestions for Microsoft because it is much too late for that. Microsoft is likely all done coding and now we just wait for them to polish up. But hey, a man can have wishes, and here are mine. I have put them in order of how much I care… Power Pivot For All Office 2013 was a complete fiasco for Power Pivot. Originally it was only available via volume licensing before public outcry allowed folks to buy the standalone version of Excel to get the Power Pivot Continue Reading