Calculate % of total that updates with filter

[Anonymous]

Hi!

I am trying to create a measure that will give me the % completed by an individual. (Need to have 2 items selected - individual and company - in same category)
So far I have created the measure for a specific person, but have 80 or so other people I need to find the same calculation for. Is there a way to select/slice the data to show the individual selected rather than having to create a separate measure per person?

It's % completed by individual so I have: % = A/(A+C)
A=person
C= company

ex. % is 1.5% for A, I need to calculate the % for b, d, e, f, g... would like it to be dynamic so I can select b and it auto updates measure.
Provider:          completed
a                        5
b                        6
c (company)      15
d                         5
e                         3

but had to create additional measures to pull the A and C counts.

I tried filtering by name of person, but the issue is the Companies are within the same column so when I filter, it won't acknowledge the Company as well, only A.

Any help would be appreciated!

[Fowmy]

@Anonymous 

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

[Anonymous]

For the Individual Count I created this measure:

A Count = CALCULATE(COUNTROWS('Facilities WO'),SEARCH("A",'Facilities WO'[Service Provider (groups)],,0))

and broke out the company count in the same fashion:
Vendor Count = CALCULATE(COUNTROWS('Facilities WO'),SEARCH("Vendor",'Facilities WO'[Service Provider (groups)],,0))

Since the "Vendor" is an entry in the Service Provider (groups) field, when I filter the Service Provider (group)= A, my calculations involving "Vendor" turn to eith 100% or [blank]

[v-easonf-msft]

Hi, @Anonymous 

If it is convenient, can you provide some smaple data in excel for further researching?

Best Regards,
Community Support Team _ Eason