Forum Discussion
Fact Table Values Showing Blank When Including Dimension Field
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.
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.
It is intended to be blank as not all sales are attributed to salespeople. I would expect the Name to be blank, but not profit in this case.
Either way, I may just create a filler CustomerAssignmentsID for null values.
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.