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

Exam 70-778 All Questions

View all questions & answers for the 70-778 exam
Go to Exam

Exam 70-778 topic 1 question 31 discussion

Actual exam question from Microsoft's 70-778
Question #: 31
Topic #: 1
[All 70-778 Questions]

You have the following tables.

There is a many-to-one relationship from Subscriber to Date that uses Subscriber[StartDate] and Date[Date]. The Cross filter direction of the relationship is set to
Single.
You plan to create a column chart that displays the following two measures:
✑ Count of SubscriberID by Month based on the StartDate
✑ Count of SubscriberID by Month based on the EndDate
What should you do before you create the measures?

  • A. Create an active one-to-one relationship from Subscriber[StartDate] to Date[Date].
  • B. Change the Cross filter direction of the active relationship to Both.
  • C. Change the active relationship for many-to-one.
  • D. Create an inactive many-to-one relationship from Subscriber[StartDate] to Date[Date].
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
References:
https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships
by AnetaK at July 17, 2019, 10:28 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
AnetaK
Highly Voted 5 years, 9 months ago
It should be E. Create an inactive many-to-one relationship from Subscriber[EndDate] to Date[Date].
upvoted 39 times
AnetaK
5 years, 5 months ago
I see... In E there is a [StartDate], not [EndDate].
upvoted 2 times
...
...
Tof
Highly Voted 5 years, 8 months ago
It should be D. First create inactive relation M-1 from subscriber[EndDate] to Date[Date]. Then Use USERELATIONSHIP in calculcate count()
upvoted 23 times
imran
5 years, 7 months ago
you are assuming things
upvoted 6 times
Tof
5 years, 7 months ago
No assomption, juste adds. Question is What should you do before you create the measures? Answer is D, then i explain how to create the measure.
upvoted 5 times
AnetaK
5 years, 5 months ago
In D there is a [StartDate], not [EndDate]
upvoted 2 times
...
...
...
Mo2011
4 years, 8 months ago
This relationship is already active
upvoted 1 times
...
...
Lhouss
Most Recent 4 years, 5 months ago
Only valid point is D. One of the two relationships should be active and here the master of the exam have choosed to have StartDate>Date inactive and EndDate>Date active !
upvoted 1 times
...
CDL
4 years, 6 months ago
no correct option. [StartDate] to [Date]: many to 1, active [EndDate] to [Date]: many to 1, Inactive. DAX: CALCULATE( COUNTROWS(Subscriber) ,USERELATIONSHIP('Date'[Date], Subscriber [EndDate]) ) Link: https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive
upvoted 2 times
...
rgt2
4 years, 7 months ago
Check this for understanding https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive
upvoted 1 times
...
itsmahouch
4 years, 7 months ago
E ? i can't find the E option !!
upvoted 4 times
...
cromastro
4 years, 8 months ago
I can't see how you get there with B ... BUT, if I eliminate all the answers that I know are wrong, which is A, C, D ... I end up with B. In the end, I agree with Rick7876 as I can write DAX measure in about a minute.
upvoted 1 times
...
J55889
4 years, 10 months ago
Agree with @sumitmalik.
upvoted 1 times
...
sumitmalik
4 years, 11 months ago
It should be E. Create an inactive many-to-one relationship from Subscriber[EndDate] to Date[Date].--> is correct
upvoted 9 times
...
AbhishekRai
4 years, 11 months ago
The answer should be B. It cannot be D coz, we already an active relation between Subscriber[Start Date] and Date[Date] mentioned in the question. How can we again talk about and inactive relation between the same columns. If it was Subscriber[End Date] and Date[Date] that would have made sense.
upvoted 7 times
...
Den2020
4 years, 12 months ago
Well, inactive relationship between EndDate and Date is needed, it's not in the list of answers... Second measure would be something like that calculate(count(Subscriber[EndDate]),USERELATIONSHIP(Subscriber[EndDate],Date[Date]))
upvoted 3 times
Sam25
4 years, 11 months ago
Agreed.
upvoted 1 times
...
...
devhawkio
4 years, 12 months ago
I had no idea you could USERELATIONSHIP of inactive relationships. Very cool and going to production now
upvoted 1 times
...
SaidDjaiz
5 years, 2 months ago
i think Correct answer is D https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi
upvoted 2 times
...
raspberry
5 years, 2 months ago
The answer is D. There already is relationship between Subscriber[StartDate] and Date[Date]" but option D asks you to create INACTIVE relationship. To do that you first have to create a different ACTIVE relationship between Subscriber[EndDate] and Date[Date].
upvoted 6 times
...
Ricky7876
5 years, 2 months ago
There is no correct option... You would need to create an inactive relationship between 'Subscriber'[EndDate] and 'Date'[Date]. The first measure is a simple COUNTROWS('Subscriber') and the second measure is a CALCULATE( [first measure], USERELATIONSHIP ( 'Subscriber[EndDate], 'Date'[Date])). The report slices or filters by Month.
upvoted 4 times
...
szaf
5 years, 3 months ago
I agree with Tof. Answer should be D.
upvoted 1 times
...
Dontpanice
5 years, 3 months ago
I think it is B and the explanation is very simple. they want the count by MONTH and since a MONTH can have several start/enddates and since start/enddates can have several MONTHS the relationship between the tables should be both.
upvoted 3 times
...
Load full discussion...
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