How to solve this issue with miss matching IDs?

[selected_]

delete

[v-lgarikapat]

Hi @selected_ ,

Thanks for reaching out to the Microsoft fabric community forum.

@MFelix 

Thanks for your prompt response

@selected_ 

Based on the screenshot, there’s a mismatch between FactTable[CategoryID] and Dim_Category[CategoryID], even though there are no blank or null values in either column. Here's how I approached the troubleshooting:

Checked for data type mismatches between columns both must be identical (e.g., Text vs. Number).

Inspected for extra spaces or casing issues using LEN(), TRIM(), and UPPER() in calculated columns.

Ran DAX using EXCEPT() to confirm:

40 IDs in FactTable aren't present in the dimension.

4 IDs in Dim_Category aren't referenced by fact rows.

If you are still encountering any challenges, we would be happy to assist you further.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
Lakshmi.

[v-lgarikapat]

Hi @selected_ ,

I wanted to follow up and confirm whether you’ve had the opportunity to review the information we provided. If you have any questions or need further clarification, please don’t hesitate to reach out.

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

Best Regards,

Lakshmi

[v-lgarikapat]

Hi @selected_ ,

I just wanted to check if your issue has been resolved. If you still have any questions or need help, feel free to reach out I’m happy to assist.

Thank you for being an active part of the community. Looking forward to hearing from you!

Best regards,
Lakshmi

[v-lgarikapat]

Hi @selected_ ,

I just wanted to check if your issue has been resolved. If you still have any questions or need any help, please feel free to reach out  I’m happy to assist.

Thank you for being an active part of the community. I look forward to hearing from you!

Best regards,
Lakshmi

[MFelix]

Hi @selected_ ,

This is a question about the data source itself, and it's not because of blank values but because of no matching values.

Let's assume a simple example:

Has you can see the value 1 that is only available on the dimension show a blank on the Fact when place on a visual and values 4 and 5 since they are not present in the dimension they show blank also on the same visual.

This means that you do not have a match between both tables, if the fact that you have certain dimension values that are not present on  the fact table is not a problem since the totals for that specific line is zero, the value not present only on the fact table are a real concern since you may be not considering values for your totals.

In my example if I want the sum of all the values of the fact table for the dimensions the 4 and 5 would be missing from that total or would be showed has blanks dimension depending on your setup.

I would advise you to check the source and correct the non matching ones.

[selected_]

Please check your PM.