Forum Discussion

ERing's avatar
ERing
Post Partisan
1 year ago
Solved

How can I solve this data quality issue?

I have a report like below where I'm showing some marketing data. My Fact_Table is connected to my Marketing_Channel_Mapping Table on Marketing_Channel_ID. My end previously has this report in Exc...
Need Help
  • Thejeswar's avatar
    Thejeswar
    1 year ago

    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,

ERing's avatar
ERing
Post Partisan
1 year ago

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.


Thejeswar's avatar
Thejeswar
Super User
1 year ago

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,