Forum Discussion

B_Rax's avatar
B_Rax
Helper I
2 years ago
Solved

Fact Table Values Showing Blank When Including Dimension Field

I have a 'Sales' as a fact table in my model. I have another two dimensions which assigns salespeople to invoices based on a compound key 'CustomerAssigmentsID' comprised of [Branch], [Date], and [Cu...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi B_Rax ,

    I understand what you're saying, and I know it's not an oversight on your part that's causing the table to show up blank with no data in it.

     

    But what I mean is that when it's blank, they don't create a direct connection between them, and in many-to-many it creates a misconnection internally, making the final result incorrect.

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

B_Rax's avatar
B_Rax
Helper I
2 years ago

Here's the link to an example pbix I created: PBIX

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi B_Rax ,

I opened your .pbix file and I found that the problem is that in the table Sales when Number is equal to 7412, it has an empty CustomerAssignmentsID, which causes it to not be able to locate the Name when trying to add it in, making it end up as full.

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.