Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.1k views
in Technique[技术] by (71.8m points)

powerbi - Which table gets expanded in DAX CALCULATE/SUM?

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...