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
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" directionThank you for your reply.