Hello,

I am trying to calculate the percentage of sales that an employee has met. I am providing a sample table here. I have a table that looks like this:

I am trying to calculate the pecentage of sales that an employee has met.

My current calculation is as follows,

Percentage of Sales Target Met =

DIVIDE(

CALCULATE(COUNT(‘Table’[EMPID]),FILTER(‘Table’,‘Table’[Sales Percentage Met]=“Yes”)),

CALCULATE(COUNT(‘Table’[EMPID]),ALLSELECTED()))

However, I realized that my denominator is taking in the overall for all of the employees instead of just the particular employee (For example for Emp 101, the percentage would show 75%). I was wondering if somebody could help me out here. I am attaching the file here.

Thank you

Percentage of Sales.pbix (23.3 KB)