Back to lesson
1. How do we refer to a measure when we want to use it in another formula?
Result = TableName[MeasureName] * 1.5
Result = [MeasureName] * 1.5
Result = (MeasureName) * 1.5
2. What is the recommended way to perform division calculations with measures?
Result = DIVIDE([Measure1],[Measure2],BLANK())
Result = [Measure1]/[Measure2]
Result = DIVISION([Measure1],[Measure2])
3. Where can you store your measures?
Measures can only be stored on the first table in the model
Measures can only be stored on the table that the measure references
Measures can be stored on any table, as long as the measure is fully qualified
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement