How should you configure the relationship from Sales to Item?

You plan to create a Power BI report You have the schema model shown m the exhibit. (Click the exhibit. button.) The model has the following relationships:

You configure row-level security (RLS) so that the district managers of the stores only see the sales from the stores they manage.

When the district managers view the sales report, they see Sales by Items for all the stores.

You need to ensure that the district managers cart see Sales by Hems for the stores they manage only.

How should you configure the relationship from Sales to Item?

A . Change the Cardinality to One to one (1:1).
B . Change the Cardinality to One to Many (1:*).
C . Select Assume Referential Integrity.
D . Change the Cross filter direction to Both.

View Answer

Answer: B