Blank rows due to data modeling problem

[Alex_Hasan]

Hi, I am very ameature in finding mistakes. Look at the Adjustable Race and Chain, no value is showing here. I've given you the link of this file https://1drv.ms/u/s!AtNgJBWI0wXOddMheymYlp08Ci0.  You'll find it in Best Selling page. Please help me to find out the mistake. 

[jdbuchanan71]

Not really a clean way, no.  The easiest thing to do is make sure that all DimProduct entries have a ProductSubcategoryKey that can map to DimProductSubcategory table.

[Alex_Hasan]

This is Adventureworks DW SQL Database. This is the limitation. 

[Alex_Hasan]

Is there any way to fill up this blanks using a calculated column? 

[jdbuchanan71]

@Alex_Hasan 

It's because the 'DimProduct'[ProductSubcategoryKey] is empty for some entries.  The DimProductSubcategory table must have the blank row added to it.  All the records from the DimProduct table that do not have a ProductSubcategoryKey map to the blank row in the DimProductSubcategory table.