In Power BI, a model can have multiple relationships between two tables, but only one relationship can be active at a time. Active relationships filter data by default, while inactive relationships are ignored unless explicitly activated using DAX functions like USERELATIONSHIP(). Understanding the difference helps build accurate data models and avoid filter conflicts.
Time limit: 0
Quiz Summary
0 of 15 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
What is the main difference between active and inactive relationships in Power BI?
Correct
Incorrect
Question 2 of 15
2. Question
How many active relationships can exist between two tables at a time?
Correct
Incorrect
Question 3 of 15
3. Question
What visual cue indicates an inactive relationship in Model View?
Correct
Incorrect
Question 4 of 15
4. Question
Which DAX function is used to activate an inactive relationship in a calculation?
Correct
Incorrect
Question 5 of 15
5. Question
Why would you keep a relationship inactive?
Correct
Incorrect
Question 6 of 15
6. Question
What happens if you try to set two relationships between the same tables as active?
Correct
Incorrect
Question 7 of 15
7. Question
When might you use an inactive relationship with USERELATIONSHIP()?
Correct
Incorrect
Question 8 of 15
8. Question
Can an inactive relationship still be used without USERELATIONSHIP()?
Correct
Incorrect
Question 9 of 15
9. Question
What symbol in Model View represents the “one” side of an active relationship?
Correct
Incorrect
Question 10 of 15
10. Question
Which of the following is NOT a reason for multiple relationships between two tables?
Correct
Incorrect
Question 11 of 15
11. Question
What effect does activating an inactive relationship have on existing visuals?
Correct
Incorrect
Question 12 of 15
12. Question
Which scenario could require keeping one relationship active and another inactive?
Correct
Incorrect
Question 13 of 15
13. Question
How can you change an inactive relationship to active?
Correct
Incorrect
Question 14 of 15
14. Question
Which relationship type can be active or inactive?
Correct
Incorrect
Question 15 of 15
15. Question
What is the main benefit of using inactive relationships strategically?
Correct
Incorrect
Summary
These Active vs Inactive Relationships in Power BI MCQs explain that active relationships automatically filter visuals, while inactive ones require USERELATIONSHIP() to be used. Strategic use of inactive relationships prevents filter conflicts and supports multiple analytical perspectives within the same model.
At QuizOrbit, our team specializes in fun, informative quizzes across topics like general knowledge, technology, and entertainment. Boost your knowledge with our expert-designed quizzes.
