Find count of measure

[slakshmip07]

Hi,

I have a table "Employee". Below is how it looks.

I have a measure called "RatingStatus" (If an employee has done both self and peer ratings, his status is completed)
RatingStatus= IF(DISTINCTCOUNT('Employee'[RatingType])=2,"Completed","Not Completed")

I represented this as a matrix visual which looks like this:

Now, I want to calculate the count of employees whose status is "Not Completed" for each month.

Eg: Sep-20  2 (2 employees have not completed the ratings)

[slakshmip07]

Hi, Sure.
Here is the link. 

[Ashish_Mathur · Accepted solution]

Hi,

Write these measures

Measure = DISTINCTCOUNT(Sheet1[RatingType])

NotCompleted = countrows(filter(values(Sheet1[EmpName]),[Measure]=1))

[slakshmip07]

This is exactly what I wanted! Thank you so much Ashish!

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur]

Hi,

To a Table visual, drag the TimePeriod column and write this measure

=countrows(filter(values(Data[EmpName]),DISTINCTCOUNT('Employee'[RatingType])<>2))

Hope this helps.

[slakshmip07]

Hi Ashish,

It doesn't work. It just displayed the total number of employees, that is, 3 for each month.

Do you have any other suggestions on how to proceed?

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.