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

  • End-User Filtered Export capabilities now available February 13, 2019
    For the third straight week, we’re delivering on the item I’ve heard more end-user feedback around than any other we’d promised to deliver in the October blogpost.  At long last, you and your users will be able to export their Power BI reports to either PDF or PowerPoint and have their selections on the screen […]
  • Incremental refresh & query folding February 13, 2019
    As part of our strategy to converge enterprise and self-service BI on Power BI as a single platform, we announced the public preview of incremental refresh last summer. While there is still more work to be done to get it to general availability, we have seen strong uptake of incremental refresh. Incremental refresh is a […]
  • Microsoft a Leader in Gartner’s Magic Quadrant for Analytics and BI Platforms for 12 consecutive years February 13, 2019
      We’re very grateful to our customers, our community members, and our partners for making Power BI what it is today.   Thank you.   The Power BI Team       Get the 2019 Gartner’s Magic Quadrant for Analytics and Business Intelligence Platforms report* to learn more.             *This graphic […]