Power BI vs Excel

A dedicated forum to help people when working through the book "Learn to Write DAX"
rfisher72
Posts: 1
Joined: Fri Jan 27, 2017 12:20 pm

Power BI vs Excel

Postby rfisher72 » Fri Jan 27, 2017 12:30 pm

I'm working through the exercises in the book a 2nd time, but this time in Power BI. For some reason, the measure to calculate total # of customers (measure #9 in chapter 4) actually filters the customers so that instead of seeing 18,484 for each product category, I see 15,114 for the accessories (and so on). But when I do it in Excel, i get the correct 18,484. Does filter context in power bi work differently than in Excel?

Also - the downside of creating measures in Power BI is that you don't have a "check formula" button such as the one in Excel. Unless I am missing something. Does Power BI offer an alternative?

MattAllington
Posts: 873
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Power BI vs Excel

Postby MattAllington » Sat Jan 28, 2017 4:48 pm

You are correct in both instances. Take a look at the relationship in Power bi between customers and sales. It will be bidirectional filtering. If you change it to single direction, it will work like Excel. Bi directional is only available in Power bi, and it comes with a performance overhead (so I generally don't like it).

There is no check formula, but there is intellisense and syntax colouring and also bracket matching, so that helps.
Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax


Return to “Help with the Book "Learn to Write DAX"”

Who is online

Users browsing this forum: No registered users and 1 guest