QuestionQ5

VerifiedImplement and manage semantic models

You have a Fabric tenant that includes a semantic model named Model1. Model1 includes a fact table named FactSales. FactSales has a relationship with a dimension table named DimDate through a column named OrderDate.

You add a second relationship to FactSales between FactSales and DimDate, based on a column named ShippedDate.

You need to filter by using ShippedDate in a new report. The solution must not affect how existing reports function.

Which two actions should you take? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

Choose two
Explanation

Keep the OrderDate relationship active to preserve existing report behavior, and keep the ShippedDate relationship inactive. A measure can use USERELATIONSHIP within a filter-taking function such as CALCULATE to activate the ShippedDate relationship only for that calculation, without changing the model’s default active relationship.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!