Page 1 of 1

Power BI vs Excel

Posted: Fri Jan 27, 2017 12:30 pm
by rfisher72
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?

Re: Power BI vs Excel

Posted: Sat Jan 28, 2017 4:48 pm
by MattAllington
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.