Thinking in DAX: Counting Products in the Current Status with PowerPivot

One of my readers came to me with an interesting formula to compute in PowerPivot. Even if I dont normally post about very specific scenarios, I think this time it is interesting to write a blog post since the formula can be easily created, if you think at it in DAX, while it is very hard if you are still approaching it with an MDX or SQL mindset. Thinking in DAX is something that comes after a lot of formula authoring, something that all BI professionals should strive for, as Vertipaq in the new SSAS engine is approaching pretty fast!