Guide to DAX Ch 9 - Calculation Groups

Question 1

What are two best practices when working with calculation items?

Answer 1

1. Use them only to modify the behavior of one measure, not a complex calculation.
2. Avoid using sideways recursion in a calculation group that is public. When using sideways recursion, be careful to avoid full recursion.

Question 2

What function is used often in a calculated item to allow a certain behavior to be applied to different measures?

Answer 2

SelectedMeasure