Percentage of Sales Target Met

DAX DAX Calculations
1

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:
image

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()))

image

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)

2

Hello @supergallagher25,

Thank You for posting your query onto the Forum.

Is this the type result that you’re looking for? Below is the screenshot provided for the reference.

Percentage of Sales Target Met

I’m also attaching the working of the PBIX file for the reference.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Percentage of Sales.pbix (24.8 KB)

3

@supergallagher25,

This what you are looking for:

image

image

Here is revised file:

ENDA Forum Percentage of Sales.pbix (23.8 KB)

** In these situations I always use variables to help solve the issue**

Thanks
Jarrett

4

@Harsh,

We must have posted each of our replies in a matter of seconds! Too funny :grin:

Thanks
Jarrett

1 Like
5

Thank you so much.

1 Like