Introduction to DAX

Question 1

What direction does related() move in?

Answer 1

From the many side to the one side

Question 2

Does related() transverse all of the many to one relationships?

Answer 2

Yes

Question 3

Relatedtable() returns…….

Answer 3

a table containing all the rows of a table on the many side that have a relationship with the current row on the table on which we define the column or we write the expression.

Question 4

Calculated columns add ___ and ____ to your model

Answer 4

Size and Memory

Question 5

What are calculated at the report level? What are calculated line by line in your model and NOT at the report level?

Answer 5

Measures, calculated columns

Question 6

When are calculated columns usually used?

Answer 6

When you need to slice

Question 7

Measures are computed in the context of the report? (True/False)

Answer 7

True

Question 8

What do iterators do?

Answer 8

Iterate over the table and evaluate the expression for each row (at report level)

Question 9

Is it better to use SUM() or SUMX()?

Answer 9

There is no difference, SUM(Table[Column]) translates to SUMX(Table,Table[Column]) on the backend.

Question 10

What can you replace multiple || operators with?

Answer 10

You can replace multiple || operators with the IN function or the SWITCH function.