% Deals made by certain individuals

[Anonymous]

Hi,

How do you find the percentage of 'deals' made by certain individuals as a fraction of the total deals? My attempt at DAX to get the total number generated by the individuals is:

Deals Originated by Team = CALCULATE(count(Query1[Closing Date]), IF(Query1[Deal Owner]  .....

How would I write the DAX so that I have the total number by the individuals im looking at, say Deal Owners 'AA', 'BB', 'CC', as a fraction of the total Closing Date (which is my count for total deals). Thanks!

[Anonymous]

[Total Deals] = COUNT( Query1[Closing Date] )

[Deals Originated by Team] =
DIVIDE(
	[Total Deals],
	CALCULATE(
		[Total Deals],
		ALL( Query1[Deal Owner] )
	)
)

... with the proviso that single-table models will make you cry one day. You should stay away from them if you want to be sure that your figures are always correct. If you want to know why, please read this https://community.powerbi.com/t5/DAX-Commands-and-Tips/Why-one-table-models-will-produce-WRONG-NUMBE...

[Anonymous]

Hi thanks for your help, how do I get the percentage for the people I am trying to filter for within Deal Owner? Deal owner includes multiple teams but need 3 people as a percentage of everyone in Deal Owner. Thanks

[Jos_Woolley]

Hi,

A small example dataset together with expected results would be really useful here.

Regards

[Anonymous]

Hi, I can't do that I'm using a live dataset for a company, but there's about 20 names within Deal Owner, and I need the sum of 3 peoples deals: CM, BC and CB, as a percentage against the total deals, hope this helps, thanks

[Anonymous]

@Anonymous 

My formula gives you what you want when you slice by Deal Owner. If you select the deal owners (CM, BC and CB), you'll get their share among all the deals.

If this is not what you're after (but this is what I've understood), then you have to be more precise.

[Jos_Woolley]

But surely you can create a small example using some dummy data?

Regards