Learn Power BI

Blog
Practice Questions

Learn Power BI

Accelerate your Career and Get Certified

Use relationships effectively

Wednesday, April 7th, 2021

Welcome to your Use relationships effectively

Questions are based on this module

The solid line between the two tables indicates that it is _______ relationship.

an inactive

the active

The dashed line between the two tables indicates that it is _______ relationship.

the active

an inactive

An inactive relationship will never be used unless ________.

Both fields in the relationship are added to the view

Both fields in the active relationship are added to the view

Explicitly declared in a measure

This function

Sales by Ship Date = CALCULATE(Sales[TotalPrice], USERELATIONSHIP('Calendar'[Date], Sales[ShipDate]))

Allows total price to be calculated using the inactive relationship between 'Calendar'[Date] and Sales[ShipDate]

Creates an active relationship between ShipDate and the calendar date

Time is Up!

Time's up

About the Author: Lukas Halim

I earned a Masters in Analytics from NC State in 2013 and now work as a data analyst in the health insurance industry. Using tools such as SAS, Tableau, and Teradata, I conduct analysis to help my company improve healthcare affordability and customer engagement.

Learn More

4.6 Instructor Rating
53,604 Students

14,612 Reviews
2 courses

Leave a Reply Cancel reply