Forum Discussion
Helper IMapping one account with two sales rep
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.
I understand. Is it possible to implement my suggestion about creating an Id column and duplicating the orders attached to account code 30?
Helper ISure, I will implement it.
Once done, and connected, we will need to go back with your dax formula I assume
- rbrechet
Yes it works this way !!!
Many thanks, I will deal with it now, espcially if multiples product/date lines per accounts.Thanks for patience and solution :) :)
No problem, always feel free to contact me if you have any kind of trouble with Power BI :)
- rbrechet
Done :)
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.