Exam 70-779 topic 1 question 4 discussion

Actual exam question from Microsoft's 70-779

Question #: 4
Topic #: 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Power Pivot model that contains the following tables.

There is a relationship between Products and ProductCategory.
You need to create a hierarchy in Products that contains ProductCategoryName and ProductName.
Solution: You create a measure that uses the USERELATIONSHIP DAX function.
Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️

by cs3122 at Jan. 20, 2020, 6:15 p.m.

Comments

Submit Cancel

cs3122

Highly Voted 5 years, 6 months ago

The relationship already exits, therefore you shouldn't need to use the USERELATIONSHIP function.

upvoted 10 times

...

Dev28

Most Recent 5 years, 3 months ago

But is it possible to create hierarchy for column that exists in 2 different tables ?? i failed to so. i am new to this, could someone please explain this.

upvoted 2 times

Sachin08

5 years, 1 month ago

Use have to use Related DAX function to use column from a different table. Refer: https://support.microsoft.com/en-us/office/hierarchies-in-power-pivot-002cf883-3b5f-497c-bfa1-ab2271cdb73b

upvoted 3 times

...

r8d1

5 years ago

Yes, same table! If different tables then look at Sachin08's answer & link.

upvoted 1 times

...

mohacoldsnake

4 years, 8 months ago

They should be on the same table. That's why it's better to create a column for ProductCatgoryName in Product table using the related function and then you can create the hierarchy. There is only one relationship here so we use RELATED instead of USERELATIONSHIP.

upvoted 2 times

...

lozqt

5 years, 4 months ago

Also USERELATIONSHIP overrides the default, active relationship between two tables hence if you use that function it will override the pre-existing link between the columns which will restrain you from creating the given hierarchy….

upvoted 3 times

...