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

  • Using XMLA endpoints to change data sources in a Power BI dataset April 19, 2021
    The purpose of this article is to provide Power BI developers with a deeper understanding of the dependencies when updating data sources in a Power BI dataset through XMLA endpoints. Most importantly, Power BI maintains security-related data source information such as credentials and privacy settings outside the dataset, whereas Azure Analysis Services and SQL Server […]
  • Power BI April 2021 Feature Summary April 16, 2021
    Welcome to the first Power BI feature summary of the Spring! In this update we have an exciting new preview for the Power Automate visual! Also, the ongoing previews (Small Multiples and DirectQuery for Power BI datasets and Azure Analysis Services) are getting some new features. Next to that, we are presenting huge improvements to […]
  • Announcing the new Power Automate visual for Power BI reports April 15, 2021
    Empower your end-users to go from insight to action. With the new Power Automate visual, end-users can run an automated flow all within a Power BI report. Furthermore, the executed flow can be data contextual, meaning that the Flow inputs can be dynamic based on the filters set by the end-user.