I am new to the concept of table expansion and trying to understand which of the table gets expanded?
For example in the following formula the tableX gets expanded:
Example 1 =
SUMX(tableX, tableX[col1])
However, for the formula examples given below:
Example 2 =
SUMX( VALUES( TABLE1[col1]),
CALCULATE( SUMX(TABLE2, EXPR) ) )
Example 3 =
CALCULATE(SUMX(TABLE2, EXPR), TABLE3[col1]=10)
Example 4 =
CALCULATE(SUMX(TABLE4, EXPR), FILTER(ALL(TABLE5), TABLE5[col1]=10))
Which of the above tables get expanded?
Generally in a DAX formula what is the concept that decides which table gets expanded?
question from:
https://stackoverflow.com/questions/65864174/which-table-gets-expanded-in-dax-calculate-sum 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…