Thanks to SimonNU at the Mr Excel Power BI forums for this question: Would a measure process slower if there are many embedded measures inside of it? A basic example for illustrative purposes: which would be a quicker measure for [Bikes]: 1. Generic Amount:=SUM([Col a]) Bikes:= CALCULATE([Generic Amount],[Col b] = "Bikes") 2. Bikes:= CALCULATE(SUM([Col a]),[Col b] = "Bikes") I admit I have had the same question, but so far properly suppressed it, but… fine, since you asked, let’s Continue Reading
Power Update
If you read my blog, there is a 95% chance you also read the blog over at PowerPivotPro, but if you haven’t seen their announcement, feel free to head on over! Come back for my thoughts: http://www.powerpivotpro.com/2015/02/introducing-power-update/ There is a bunch of questions I ask new clients… about the size and nature of their data, how they get final reports out to the folks that want to see them, etc. And there is a lot of dancing around this theme of “how and when Continue Reading
This is not the post I planned to write…
I’ve got this theory. It’s based on incomplete understanding, so… I strove forth to complete the understanding and totally failed. It’s basically that… =CALCULATE([Calc], MyTable[Col1] = 5, MyTable[Col2] > 10) should be faster than =CALCULATE([Calc], FILTER(MyTable, MyTable[Col1] = 5 && MyTable[Col2] > 10)) Let us take this journey of failure together, and see what we can learn Continue Reading
What is new in the world of Microsoft BI?
Edit: Not sure if my timing could have been more amusing with this entry... but the day after I wrote this Microsoft really pulled out all the stops! http://blogs.microsoft.com/blog/2015/01/27/microsoft-brings-business-intelligence-mainstream-enhancements-power-bi/?linkId=11984318 Well, quite a lot. Those crazy kids… …Launched a new BI Designer …Launched a new BI Dashboard …Released a freaky REST API …bought a company! This while they march along with releases of Power Query, Power Map, Continue Reading