Count if equals null()

[cawestelaken]

Hello,

I'd like to show the amount of open tickets which do not have an assignee (look at situation below)

To do this I've used the following measure:

count(if([Ticket.Assignee]=null(),[_Flag_TicketOpen]))

But for some reason it does not give the results expected.

In the picture below, in the left table you can see all open tickets. In the right table you can see all unassigned open tickets, in this table the above measure is included.

In the table underneath you can see that these selected tickets most definitely have a null value as [Ticket.Assignee].

Am I doing something incorrectly? Or is there a better way to achieve this effect?

Yours sincerely,
Casper Westelaken

[agigliotti · Accepted solution]

maybe this:

count( if( IsNull([Ticket.Assignee]),[_Flag_TicketOpen] ) )

[juraj_misina]

Maybe try

count(if(IsNull([Ticket.Assignee]),[_Flag_TicketOpen]))

But the best approach would be to replace null with some value (e.g. "unassigned" or something) during data load, then you could easily filter on that value.

Hope this helps

Juraj

[cawestelaken]

As stated in the correct answer, that indeed works... Sadly with the loading, I do not control this myself, so I'd have to try to fix that higher up.