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

  • On-premises data gateway October 2021 update is now available October 20, 2021
    On-premises data gateway (standard and personal mode) release for October 2021
  • Power BI Desktop Installer Changes & WebView2 October 13, 2021
    As mentioned in the June and July feature summaries, we are switching a vital component of Power BI from CefSharp to WebView2. We’re making this switch to better optimize our development and release process (which means we’ll be able to spend more time developing new features!). It also means that you’ll automatically get the latest […]
  • Power BI October 2021 Feature Summary October 12, 2021
    Welcome to the October 2021 update. Leaves fall, Power BI calls; and we are excited to release additional functionality and performance improvements for DirectQuery, optimization for the SWITCH function,  and new Bitwise DAX functions.