cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Clay82
Frequent Visitor

Data modelling issue

Hi all,

 

New to Power BI and have come across a dataset that I am exploring and have an issue that I don't know how to solve when it comes to modelling and building relationships. 

I was hoping to get some help from the community.

 

I have this table with three columns that I have renamed to "Inventory_Lookup" (see pic) that I'm not able to connect correctly. I have listed my questions below. 

- Is this  a lookup/dimension table? Or is it actually a fact/data table?

- How do I connect it properly since there are no unique values in the table? Have I done it the right way as shown in the picture (both directions from sales table to product_lookup and one to many from product_lookup to Inventory_lookup)?

 

Thanks in advance.

 

Inventory_table.PNGRelationships.PNG

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

Hi @Clay82 ,

 

  1. The Inventory_Lookup is not a dimension table. A dimension table only rows with unique key values. It is a FACT table I would say.
  2. Product_Lookup to Inventory_Lookup relationship looks right.
  3. Sales to Product_Lookup relationship depends on what you want to retrieve based on this relationship? Do you want to access details in SALES table using Product_ID from PRODUCT_LOOKUP table? If yes then this relationship will work. But suppose you are planning to retrive "Stock_On_Hand" information in Sales table then you can also consider a direct relationship between SALES and Inventory_Lookup.

But, yes all the relationships in a data model depend on what you re planning to analyse in your report and at what granularity.

 

Thanks,

Pragati


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

2 REPLIES 2
Pragati11
Super User
Super User

Hi @Clay82 ,

 

  1. The Inventory_Lookup is not a dimension table. A dimension table only rows with unique key values. It is a FACT table I would say.
  2. Product_Lookup to Inventory_Lookup relationship looks right.
  3. Sales to Product_Lookup relationship depends on what you want to retrieve based on this relationship? Do you want to access details in SALES table using Product_ID from PRODUCT_LOOKUP table? If yes then this relationship will work. But suppose you are planning to retrive "Stock_On_Hand" information in Sales table then you can also consider a direct relationship between SALES and Inventory_Lookup.

But, yes all the relationships in a data model depend on what you re planning to analyse in your report and at what granularity.

 

Thanks,

Pragati


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

Clay82
Frequent Visitor

Many thanks @Pragati11 !

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors