ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 42 discussion

Actual exam question from Microsoft's PL-300
Question #: 42
Topic #: 2
[All PL-300 Questions]

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 BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:
✑ Due Date
✑ Order Date
✑ Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: You create measures that use the USERELATIONSHIP DAX function to filter sales on the active relationship between the sales table and the date table.
Does this meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by legionairemax at Sept. 17, 2022, 4:40 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
fdsdfgxcvbdsfhshfg
Highly Voted 2 years, 7 months ago
Selected Answer: B
You can't use USERELATIONSHIP() to filter on an active relationship, but need additional innactive relationships
upvoted 42 times
Grexx
2 years, 6 months ago
https://learn.microsoft.com/en-us/dax/userelationship-function-dax "In USERELATIONSHIP, the status of a relationship is not important; that is, whether the relationship is active or not does not affect the usage of the function. Even if the relationship is inactive, it will be used and overrides any other active relationships that might be present in the model but not mentioned in the function arguments."
upvoted 25 times
...
...
Hoeishetmogelijk
Highly Voted 2 years, 5 months ago
Selected Answer: B
Actually the DAX USERELATIONSHIP() function could offer a solution, but not how it is stated as an option: "You create measures that use the USERELATIONSHIP DAX function to filter sales on the ACTIVE relationship between the sales table and the date table." Because the report must be filtered on all 3 dates, the ACTIVE (1) AND INACTIVE (2) relationships should be used with function USERELATIONSHIP, not only the ACTIVE relationship.
upvoted 30 times
ZSun
1 year, 9 months ago
Correct Answer!. The method "USERELATIONSHIP" DAX FUNCTION is right, but the explanation which only limited to active relationship is wrong.
upvoted 5 times
...
...
0f4908c
Most Recent 2 months, 2 weeks ago
Selected Answer: B
The question is whether it can be used in an active relationship, the answer is B!
upvoted 1 times
...
_jay95_
3 months ago
Selected Answer: A
In USERELATIONSHIP, the status of a relationship is not important; that is, whether the relationship is active or not does not affect the usage of the function. https://learn.microsoft.com/en-us/dax/userelationship-function-dax
upvoted 1 times
...
Odidepse
3 months, 2 weeks ago
Selected Answer: A
Yes create measures for sales based on the Order Date and Delivery Date using USERELATIONSHIP like this: DAX Copy code SalesDueDate = CALCULATE([Total Sales], USERELATIONSHIP('Sales'[Due Date], 'Date'[Date])) SalesOrderDate = CALCULATE([Total Sales], USERELATIONSHIP('Sales'[Order Date], 'Date'[Date])) SalesDeliveryDate = CALCULATE([Total Sales], USERELATIONSHIP('Sales'[Delivery Date], 'Date'[Date])) These measures will calculate total sales by leveraging the respective date field, even if there are inactive relationships between the Sales and Date tables for each specific date field.
upvoted 2 times
...
desibaby09
4 months, 3 weeks ago
Selected Answer: A
Yes this will provide a solution
upvoted 3 times
...
jaume
5 months, 1 week ago
Selected Answer: B
Once again I feel like I'm not being tested by my knowledge but about how carefully I'm reading the question and what's my understanding of the question. There is nothing mentioned about Sales and Date tables being linked using the three listed fields (of course not all links can be active at the same time) so this is something to be assumed and the RELATIONSHIP() function must be used for the analysis over the inactive relationships. I also think you can use RELATIONSHIP() over an active relationship (although it will have no impact at all in the calculation as the relationship is already active). At the end, I think important detail is when it's mentioned "... on the active relationship..." as there is no mention about using it on the other required relationships; for the specific active relationship, if not used with the inactive (something that is also not mentioned), it won't work
upvoted 1 times
...
LuluSkyy
6 months ago
USERELATIONSHIPS can be used regardless of the relationship. Example it can work when there's only one active relationship and 2 inactive relationship. The correct answer is A
upvoted 2 times
...
shahrzadkhb
10 months, 2 weeks ago
A is correct. In USERELATIONSHIP, the status of a relationship is not important; that is, whether the relationship is active or not does not affect the usage of the function. Check this link out: https://learn.microsoft.com/en-us/dax/userelationship-function-dax
upvoted 2 times
...
Igetmyrole
1 year, 7 months ago
A is correct. This solution meets the goal. By creating measures that use the USERELATIONSHIP DAX function, we can specify which relationship between the sales table and the date table to use for filtering in our calculations. This allows us to analyze sales over time based on all the date foreign keys, ensuring that the correct relationship is applied in each scenario.
upvoted 3 times
...
JJMC5544
1 year, 9 months ago
Selected Answer: A
You can relate all 3 date columns to Date table, and you can make all of them inactive. (2 of them will be initially inactive anyway) So you can use USERELATIONSHIP in your calculations. It's YES for me.
upvoted 2 times
JJMC5544
1 year, 9 months ago
OK, I've changed my mind, you don't use USERELATIONSHIP on active relations.
upvoted 3 times
...
...
charles879987
2 years, 2 months ago
it's not necessary to userelationship on active relationship. only inactive. furthermore, userelationship should be used on all relationships, active or inactive
upvoted 4 times
...
Nawabi
2 years, 2 months ago
Selected Answer: B
For sure B. WE don't use dax for active relationship. watch this video for understanding. https://www.youtube.com/watch?v=LfVDUiU8vaU
upvoted 6 times
Nass75
2 years ago
Thanks for the video link.
upvoted 1 times
...
...
Churato
2 years, 6 months ago
After all, Yes you will use USERELATIONSHIP BUT, not like as provided... It will be used to activate the inactive relationships as needed
upvoted 4 times
Hoeishetmogelijk
2 years, 5 months ago
It can be used for active and inactive relationships: "In USERELATIONSHIP, the status of a relationship is not important; that is, whether the relationship is active or not does not affect the usage of the function. Even if the relationship is inactive, it will be used and overrides any other active relationships that might be present in the model but not mentioned in the function arguments."
upvoted 4 times
...
...
amavidis
2 years, 6 months ago
I think it's correct, USERELATIONSHIP() on active relationships will only use one of them.
upvoted 3 times
JamieMcD
2 years, 2 months ago
You do not need to use USERELATIONSHIP() if it is already an active relationship, it is used on inactive relationships
upvoted 2 times
...
...
legionairemax
2 years, 7 months ago
The solution I believe is incorrect. The solution must be A as there is no reporting need to use all 3 dates simultaneously.
upvoted 8 times
sharmila29
2 years, 4 months ago
I was thinking the same but then if you read the options again, it says create measure on active relationship. So the answer is A is wrong , we don't create userelationship function on active relationship. No need.
upvoted 3 times
...
Dovoto
2 years, 6 months ago
"You need to support the analysis of sales over time based on all the date foreign keys." We need all 3 dates right?
upvoted 5 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago