CODEWITHSUNDEEP
filterpowerbidaxrelationship
Swarnadip Bandyopadhyay
Swarnadip Bandyopadhyay

Reputation: 1

DAX relationship

I am a beginner in Power BI. Just started working on DAX. I have a question regarding relationship. I have made four tables i.e. Sales, Products, Product Category, Product Sub Category. Found that relatable columns are automatically picked up. ProductKey column in Product table contains unique Product Key and that propagates Sales Table where Product Key gets repeated. The arrow direction is from Products table to Sales table. '1' is added to Products and a '*' is added to Sales. I think this type of relationship is called 'One to Many' but when I check the properties of the relationship it indicates as 'Many to one'. If tried to change to 'One to Many' it shows error statement. Please help me out of this problem. Thanks.enter image description here

Upvotes: 0

Views: 128

Answers (2)

AKP
AKP

Reputation: 99

There is no need to worry about your design however I will suggest you merge "Product Category" with "Product SubCategory" tables so you can achieve a star schema which works best with PowerBI.

Upvotes: 0

Syed Rehan Ali
Syed Rehan Ali

Reputation: 49

Since you are saying that Product table has '1', while the Sales table has '*', so this is a One-to-Many relationship. However, when you open the relationship properties then you see the 'cardinality' as 'Many to one'. That is only because in the 'Edit relationship' window your table selection sequence is opposite. That is, the Sales table is selected at the top and the Product table is showing in the bottom. So, summary, the relationship is correct, nothing to be worried about. :) Rehan

Upvotes: 1

Related Questions