Forum Discussion

ARU_'s avatar
ARU_
Advocate I
3 years ago
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...
"CALCULATE"
context transition
DAX
DAX ROW CONTEXT
  • tamerj1's avatar
    tamerj1
    3 years ago

    ARU_ 
    I hope the following calrifies everything

ARU_'s avatar
ARU_
Advocate I
3 years ago

Thanks tamerj1  for your prompt response. 


Sorry, i am still confused about it. Even if table variable is evaluated once, how will it change the working of 'Addcolumns' function. Suppose, the variable 'date_sale_table' generates a table in-memory. 

 

Now, in 'Addcolumns' function, we are just iterating over  'date_sale_table' variable. We are nowhere evaluating it again.. Will iterating through it also amount to evaluation?  

 

I hope, i am able to articulate my question. 

tamerj1's avatar
tamerj1
Community Champion
3 years ago

ARU_ 

Exactly. Evaluating the complete table not only the subset of rows that belongs to the current rows iterated by ADDCOLUMNS (which then converted by CALCULATE into a filter context). 

and yes you are creating multiple row contexts created by nesting multiple iterators.