Forum Discussion
Solved
Evaluation Context LOGIC on Running Total
The standard DAX expression for Running total is: Cumulative Quantity := CALCULATE ( SUM ( Transactions[Quantity] ), FILTER ( ALL ( 'Date'[Date] ), 'Date'[Date] <=...
You are perfectly correct....
Following is taken from Rob Collie and Avi Singh's famous book on Power BI
Hi migueljoa
MAX/Sum/Avg....any aggregation formulas always refer to FILTER Context.....
The only filter context that is available is from the Pivot table in your Case. So it takes the row value.....(You can use SELECTEDVALUE as well)
However if you wrap the aggregation inside Calculate function then the ROW context created by FILTER function will be transformed into FILTER context....and the filter context from the pivot would be ignored.
- Hi Zubair_Muhammad
So the Filter Context of the Pivot table is used on the MAX function because all aggregations are evaluated on a Filter Context? And ALL(Dates) overrides the filter context but only for the table that is FILTERED?
Thanks! I appreciate very much the time you have taken to answer my doubtsYou are perfectly correct....
Following is taken from Rob Collie and Avi Singh's famous book on Power BI
- I see... I must have missed that part of the reading. Everything is crystal clear now!
Thanks for putting it out for me. Greatly appreciate it!
