Microsoft
70-768 · Question #66
You are developing a SQL Server Analysis Services (SSAS) tabular project. A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The…
The correct answer is C. =RELATED(Geography.City). RELATED Function Returns a related value from another table.
Design and implement Tabular Data Models
Question
You are developing a SQL Server Analysis Services (SSAS) tabular project. A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the Geography table that is related to the Customer table. You need to add the City column to the Customer table. How should you write the calculation?
Options
- ACity:= LOOKUP(Geography[City],Geography[GeographyKey],[GeographyKey])
- BCity:= LOOKUPVALUE(Geography[City],Geography[GeographyKey],[GeographyKey])
- C=RELATED(Geography.City)
- D=VALUES(Geography[City])
- ECity:=VALUES(Geography[City])
How the community answered
(46 responses)- B2% (1)
- C85% (39)
- D4% (2)
- E9% (4)
Explanation
- RELATED Function Returns a related value from another table.
Topics
#DAX#RELATED function#calculated columns#hierarchy
Community Discussion
No community discussion yet for this question.