Counting the specific result from another measure

[sandy8910]

Hi Everyone,

I am very new to Power BI. I have the following:

1. Employee Full Name (From Emp table)

2. Employee Earned amount (From Emp table)

3. Employee Task completed  (From Emp table)

4. Total Earned amount (Measure:= Sum(Employee Earned amount))

5. Total Task completed (Measure:= Sum(Employee Task completed))

6. Earned amount per task (Measure: = Divide(Total Earned amount,Total Task Completed))

Now I need a measure that should give me the count of Employees who earned more than $2 per WOID.

Issure is when I try to use CountX or Calculated Function, It does not let me refernce the original table (I need to refer to orignial table because I want a count of Full names of Employees from table and $2 value from measure table) 

Can anyone help?

[BA_Pete · Accepted solution]

Hi @sandy8910 ,

Try something like this:

_empsEarnedOver2USD =
CALCULATE(
  COUNT(empTable[Employee Full Name]),
  FILTER(
    empTable,
    [Total Earned Amount] > 2,
  )
)

Pete

[sandy8910]

Thanks BA_Pete for quick response,

Below funcation from parry2k in another thread has helped me get the answer

COUNTX ( VALUES ( Table[Date column] ), IF ( [Your Measure] < 3, 1 ) )

[BA_Pete]

@sandy8910 ,

No problem, glad it's sorted.

Please accept your answer as the solution if you feel that it would help others with the same issue.

This helps others find the answer to their issues quicker.

Pete