Forum Discussion
Solved
Relation
Hello Experts, Question DA-100 You are creating a Microsoft Power BI data model that has the tables shown in the following table. Table Name Column name sales salesID ProductID ...
The Question "You need to ensure that you can analyze sales by product category."
no need to use "Both" direction
open Power BI desktop
On the Modeling tab, select Manage relationships > New.
In the Create relationship dialog box, in the first table drop-down list, select a table. Select the column you want to use in the relationship.
In the second table drop-down list, select the other table you want in the relationship. Select the other column you want to use, and then select OK.
The Answer Area is as follows in the exam !
Cardinality one-to-many one-to-one Many-to-many Cross filter direction single both Cardinality: one-to-many
Cross filter direction: single
Because one product category may have many products
I think like you but please check the following link:
