Forum Discussion
rbrechet
Helper I
9 years agoMapping one account with two sales rep
Hello dear community. I am facing the below challenge: I am trying to map salesforce territory with my sales data in order to follow up sales representative performance. This is normally simple...
- Anonymous9 years ago
Alright, so you make a new column in fact table called rep key. The DAX formula looks like this:
Repkey = 'Fact1 Table'[Code]&" "&'Fact1 Table'[Sales rep]
You make a similar column in your rep table:
Repkey = 'Rep Table'[code]&" "&'Rep Table'[Sales rep]
Then you create a relationship between fact table and rep table with these columns.
Then you create a calculated column with this DAX formula:
Total amount = 'Fact1 Table'[Amount] * RELATED('Rep Table'[Split])
Let me know how it goes. I'll gladly elaborate.
rbrechet
Helper I
9 years ago