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.