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 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 doubts
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 doubts
You 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!