COUNT DISTINCT NULL in left Join Table

[trishmre]

How can I count distinct Open PR for PO Creation?

I have tried the count distinct and isnull PO. But till incorrect count.

This is left join table.

[justISO]

Hi, not sure where you want to count this, in load script or report level, but as one of suggestion could be something like this:

count(distinct if (len(PO)>0, PO))

[trishmre]

Hi

I am trying to have KPI chart, I need to count the NULL PO or PO =  '-' that has PR Status  equal to Open and distinct the PR.

[justISO]

Maybe this way:

count(distinct if ((len(PO)=0 or isnull(PO)) and [PR Status]='Open', PO))

[trishmre]

Not working, I am expecting to have number of PO.

I have already count of Open PR

=Count(distinct{<[PR Status]= {'Open'}>}PR)

I need to add condition to count the null PO for the Distinct PR column that has PR Status = 'Open'

[RsQK · Accepted solution]

Hi, this?

=COUNT({<PR*=E({<PO={"*"}>}),[PR Status]={'Open'}>}DISTINCT PR)

[trishmre]

It works! thank you. I appreciate your help.