I need help with Model

Power BI Data Model
1

Hi Power BI Team,
I need recommendation of how to build model, relationship, and DAX formula to get the Sales on Invoice data.
Here is my case.
1/ Sales Rep is belong to Territory
2/ Each Customer (Bill-To) is assigned to a Territory and a Sales Rep
3/ Each Customer may have many Ship-To (Sell-To)
4/ Each Ship-To may have the same or different Sales Rep with Bill-To

I was able to get Sales for Sales Rep at either Bill-To or Ship-To, but not both.

Greatly appreciate any help or recommendation.

Alex H.

2

@AlexHuynh, Your fact table will guide how your model can be built.

What dimensions are available in your Customer Sales Facts table? A diagram is always helpful or mock pbi file.

3

Hi @AlexHuynh, we’ve noticed that no response has been received from you since December 17, 2019. We just want to check if you still need further help on this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. You may reopen a new thread when the need arises.