A couple powerBI notes

I’ve been working on a big powerBI dog and pony show lately, and have discovered a couple things in my haste.  (Not really when I want to be discovering them)

  • Filtering over a summarize or crossjoin is a terribly inefficient way to write DAX.  It will iterate over the result set, rather than apply the filter in context.


  • Whiskey does not help writing DAX.  It’s just like using the filter operator.  You think you’re efficient, but you’re really not.


  • A dimension will be restricted by the “fact” or measure tables it’s associated with if the relationship is set to “Both”.  As this is the default, it’s easy to get screwed by this, especially if you’ve had several whiskey.  In other words, if you’re associating a dimension with a fact, (or base table), it will look like the dimension has fewer keys than it actually does.


Far better an approximate answer to the right question, which is often vague, than the exact answer to the wrong question, which can always be made precise. -John Tukey
The plural of anecdote is not data. - John Myles White

Recent Posts

RSS PowerBI blog

  • Visualizing SharePoint lists now available to all users July 22, 2021
    A couple of months ago, we launched a new Power BI integration for visualizing SharePoint lists for all Targeted release users. We’re now excited to announce that the experience has rolled out to Standard release users and is now accessible to everyone!
  • Behind the scenes: Running the Power BI service July 22, 2021
    I’m excited to share a new whitepaper that describes the Power BI team’s approach to maintaining a reliable, performant, and scalable service for our customers.
  • Power BI July 2021 Feature Summary July 21, 2021
    Welcome to the July update! This month we are making small multiples generally available, as well as the new model view and sensitivity labels in Desktop. Also, we have a new preview for streaming dataflows. There is much more, so read on!