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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi B_Rax ,

Applying many-to-many relationships in Power BI is prone to errors. It's easy to create aggregation or some other unwanted error, so if you can provide me with more information about your problem or .pbix file, I think I can solve the problem more intuitively.

 

 

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