More on the CALCULATE function…

5 באוקטובר 2010

A bit more information regarding the new CALCULATE function in DAX. I’ve described what this function does in a previous post, and I want to expand on how to treat this function in a PowerPivot report. Consider the following report:     We have Order Quantity sales () and two calculated measures, which we are going to discuss shortly. We have the promotions dimension in the Y axix and 2 slicers: Product Category Name and Calendar Year. The DAX syntax for the calculated measures is as follows: Order Quantity...
2 תגובות

DAX functions – CALCULATE and CALCULATETABLE

1 באוקטובר 2010

I’m getting more and more involved in designing PowerPivot models and want to share a bit of DAX tips in the coming posts. I’ve already touched on DAX in previous posts and in this post I’d like to discuss the new CALCULATE and CALCULATETABLE functions and their uses in a model. DAX is a powerful expression language and one of its main differences from the expression language we know in Excel is the fact that we can reference entire tables rather than cells in a spreadsheet. When we need to look into a series of values in a...
אין תגובות