Chart to Show Count of Zero Values

[Geroo]

Hi

I have a request to summarise the amount of users that havent completed a task (list item in sharepoint list that I sucking in SQL)

The list of users is from our Users container in Active Directory and I have a table showing all users Count of tasks completed, I am showing the NULL values by using this measure:

Zero SOR = (COUNT(SOR[Title]) + 0)

I have a relationship between AD 'displayname' and Task List 'Created By'.  SOR is the task list and Title being the task name. 

Which works well in a table as its shows the users with a zero score along with all the other users that have completed a task (SOR). 

Now I just want to show the totals of users per department (attribute from AD) that have not completed a task.  I have tried a number of different methods such as rowcount / countblanks  etc and at present i have a measure like this:

Zero SOR Count = CALCULATE(count(user[Name]), FILTER(SOR,ISBLANK(COUNT(SOR[Zero SOR]))))

But this brings back nothing, I am finding it increasingly difficult to count nothing and not even sure if it is possible?

Any help appreciated

[Ronald123]

@Geroo ,

Try this;

Zero SOR Count = CALCULATE(count(user[Name]), FILTER(SOR, [Zero SOR]=0)

Greetz,

Ronald

[Geroo]

@Ronald123 

I have already tried that calculation in the measure and it returns nothing, thank you anyways.

It is strange as I (like you) would of thought that calculation would of worked

[Ronald123 · Accepted solution]

@Geroo ,

Check the test file.

https://1drv.ms/u/s!An5X7wdH9O9ejFdjZa9kH9J-SXcr

Greetz,

Ronald

[Geroo]

@Ronald123 

Thanks for the file, I created a new report woth just the AD User table and the task list and this works

Strangely it doesnt on my existing report so it must an issue with my relationships on the other tables i have in the report although I cannot see why at present

Thanks for the help , i wasnt going mad after all 🙂