Forum Discussion
Solved
Multiple row Context within Iterators
Hello Community, I am trying to compute a table using DAX with date wise sales and its running average of last 5 days. I have this following code which works fine. However i reached here aft...
Thanks tamerj1 -
You are a Star 🙂 Your approach of explanation is just awesome. I thank you for that.
After carefully study of your comments and computations, I think it is safe to say that Calculate context transition is ineffective on variable tables.
As an extension of the above point, i want to ask when you say that newly created filter context cannot recalculate variable table during Sumx iteration, doesn't the same logic apply to AverageX iteration?
See, my understanding of context transition is application of filters from the row being iterated to the calculate expression.
As during AverageX iteration too, you are filtering the variable table and computing Average. Doesn't this amount to recalculation of variable tables?