Forum Discussion
Relation
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:
The Question "You need to ensure that you can analyze sales by product category."
no need to use "Both" direction