Dax Calulation Help

[Alexp81]

Wondering if anyone has doen this before trying to do in report vs in sql where sales people share the sale if there is a second salesperon presant.

Sales Tables

Salesperson ID, salesvalue, secondsalesperson

What I am looking to try is sum the salesvalue for the second saleperson and have it attibute to the salesperson in a tableon power bi.  blank when only a single sapersperson.  sales person ID is linked to another table containg sales person data that does the grouping , ID is the same in primary and secondary sales

A,500,b

B,200,

A,200,

B,300,C

Expected result

SPID, Primay Sales, Secondary Sale

A,700,0

B,500,500

C,0,300

Perhaps I have missed soemthing in obvious I have managed to count the sacondary sale for the primary salesperson

Total_secondsales = CALCULATE(

    SUM('table'[Amount Including VAT]),'table'[Second Salesperson Code] <> "")

Thanks Everyone

A

[AlanFredes · Accepted solution]

Hi Alex,

I have worked with sales data like this and what did was to un-pivot the data either in SQL or Power BI Power Query to get the following structure. This also allows you to quickly toggle between what they have as a Primary or Secondary assignment.

Id	Amount	Primary/Secondary
A	500	P
B	200	P
A	200	P
B	300	P
B	500	S
C	300	S

Did I answer your question? Mark my post as a solution!

[Alexp81]

Hi Alan, thanks for the reply, thats where i had got to in my mind, hoped i had missed something.

Thank you

Alex