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 =
CALCULATE(COUNT(‘Table’[EMPID]),FILTER(‘Table’,‘Table’[Sales Percentage Met]=“Yes”)),
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.
Percentage of Sales.pbix (23.3 KB)