I do not want aggregated % totals

[cortneyakolger]

Hello, I am building a dashboard representing sales reps' market share. Currently the line chart is showing an aggregated number. How can I show each indiviudual sales reps' market share % rather than what i currently have, which if you add up, it is the whole company's market share %. I hope I communicated this correctly. Thank you in advance!

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[cortneyakolger]

Rep name	Wholesaler	Sales
bob	mike r	$  10,000.00
sally	jeff t	$  69,899.00
jim	mike r	$    5,444.00
cortney	mike r	$  32,222.00
joel	cary m	$  66,879.00
joey	cary m	$        432.00

Market Metrics Wholesaler	total office opportunity
mike r	$                    3,000,004.00
jeff t	$                        578,937.00
mike r	$                        666,793.00
carry m	$                        890,754.00
carry m	$                          27,894.00
jeff t	$                        578,075.00

Thank you. I hope I followed the article correctly so this is helpful to you. I'd like to display each wholesalers' market share (Sales/Total Office Opportunity) as a %. In addition to each wholesalers' market share, I'd like to see total market share between all wholesalers. The total market share % will sort of serve as a bench mark/how do the wholesalers compare to one another and the total %. Please let me know if you have clarifying questions. I really appreciate your help!

[cortneyakolger]

Market Metrics RVP	total office opportunity
mike r	$                    3,000,004.00
jeff t	$                        578,937.00
mike r	$                        666,793.00
carry m	$                        890,754.00
carry m	$                          27,894.00
jeff t	$                        578,075.00

Rep name	Wholesaler	Sales
bob	mike r	$  10,000.00
sally	jeff t	$  69,899.00
jim	mike r	$    5,444.00
cortney	mike r	$  32,222.00
joel	cary m	$  66,879.00
joey	cary m	$        432.00

[lbendlin]

see if the attached helps get you started.

[cortneyakolger]

Thank you a lot! This is helpful.