0
0
Power BIbi_tool~5 mins

Active vs inactive relationships in Power BI - Quick Revision & Key Differences

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Recall & Review
beginner
What is an active relationship in Power BI?
An active relationship is the main connection between two tables that Power BI uses by default for filtering and calculations.
Click to reveal answer
beginner
What is an inactive relationship in Power BI?
An inactive relationship exists between tables but is not used by default. It can be activated temporarily in calculations using DAX functions.
Click to reveal answer
intermediate
How do you use an inactive relationship in a DAX formula?
You use the USERELATIONSHIP() function in DAX to activate an inactive relationship temporarily within a calculation.
Click to reveal answer
intermediate
Why would you use inactive relationships in your data model?
Inactive relationships let you model multiple ways tables relate without confusion, like different date fields (order date vs ship date) in the same tables.
Click to reveal answer
beginner
Can you have more than one active relationship between two tables in Power BI?
No, Power BI allows only one active relationship between two tables. Others must be inactive.
Click to reveal answer
What does an active relationship do in Power BI?
AIt is ignored unless activated in DAX.
BIt deletes duplicate data.
CIt is used by default for filtering and calculations.
DIt creates a new table.
How can you use an inactive relationship in a measure?
ABy using the USERELATIONSHIP() function in DAX.
BBy deleting the active relationship.
CBy refreshing the data model.
DBy creating a new table.
How many active relationships can exist between two tables in Power BI?
AZero
BTwo
CUnlimited
DOne
Why use inactive relationships in your data model?
ATo delete unused columns.
BTo model multiple ways tables relate without confusion.
CTo speed up data refresh.
DTo create duplicate tables.
Which DAX function activates an inactive relationship?
AUSERELATIONSHIP()
BCALCULATE()
CFILTER()
DRELATED()
Explain the difference between active and inactive relationships in Power BI and when you would use each.
Think about how Power BI chooses which relationship to use automatically.
You got /4 concepts.
    Describe how to use an inactive relationship in a DAX measure and why this is useful.
    Focus on the DAX function that switches relationships.
    You got /4 concepts.