Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 | |
Datekey | |
SaleAmount | |
Products | ProductID |
ProductName | |
ProductCatagoryID | |
ProductCatogory | ProductCatagoryID |
CatagoryName |
The Products table is related to the ProductCatagory table through the ProductCatagotyID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCatagory?
Solved! Go to Solution.
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
Thank you for your reply.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |