Forum Discussion
How can I solve this data quality issue?
Hi ERing ,
You can fix this by adding a ID for the null values . This ID should also be part of the Dimension Mapping table.
The Below are the steps
1. Replaces the null values in Fact tables with an ID. In this case, I am replacing with 999
2. Add the new Id to the Dimension table.
Rest all no changes. The Output should look like shown below
Attaching the PBIX here for your reference.
Regards,
Hi ERing ,
This Data Quality Issue is because your Fact Table has some Marketing_Channel_Id values that are not present in the Marketing_Channel_Mapping Table.
The Solution is to add the missing Marketing_Channel_Id value to the Marketing_Channel_Mapping table
I have shown a sample representation below.
See Below screenshots
Fact Table:
Mapping Table:
Output:
The Above Blank can be solved by adding the missing Marketing_Channel_Id to the Mapping table
Post Adding Screenshot Below:
Regards,
Thejeswar Thanks for the reply, however I don't believe what you've described is the issue I have.
I've intentionally set up my data in the PBI file to represent the issue I'm having in my real work file.
The issue is that the Fact_Table has records with no Marketing_Channel_ID.
I've added the Excel file to my original post if it helps.Hi ERing ,
You can fix this by adding a ID for the null values . This ID should also be part of the Dimension Mapping table.
The Below are the steps
1. Replaces the null values in Fact tables with an ID. In this case, I am replacing with 999
2. Add the new Id to the Dimension table.
Rest all no changes. The Output should look like shown below
Attaching the PBIX here for your reference.
Regards,
