Average per row for each resource and sum for the total

[mimingiang]

Hi I have the first table 

Order number	Sales person
1	A
1	B
2	C
3	D

I have another table where I can calculate the sum value of the order. I would like to show on matrix levels. 

Order number	Amount
1	200
2	300
3	400

I want to get this matrix the amount on sales order amount = sum(amount)/distincount of sales person. 

[mimingiang]

Thank you @tharunkumarRTK @tharunkumarRTK. Just want to add some more details for the calculation

I have another table where I can calculate the sum value of the order. I would like to show on matrix levels. 

Order number	Amount
1	200
2	300
1	400

I have many to many relationship between Orders and Sales Persons

Order number	Sales person
1	A
1	B
2	B
3	D

I want the end result look like this 

[lbendlin]

I have many to many relationship between Orders and Sales Persons

Don't do that. Use a proper data model.

[tharunkumarRTK · Accepted solution]

@mimingiang 

I believe this is your expected result 

Please find the PBIX file 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[lbendlin]

You may want to add a Sales Person Dimension table to your data model.

Then you can use your preferred DAX to calculate the mapping.