Counting distinct Value based on two field

[DipeshVadgama]

Hi,

I am trying to count distinct value base on 2 Fields. Below is example,

Id's & Defect Code can be duplicate as per data, but I just need Unique count for ID & Defect Code.

like = Count(Distinct(ID) , Distinct(Defect Code))

Result = 5 ( Highlighted Yellow for example)

ID	Defect Code
1	11119
2	11113
2	11117
3	-
4	-
4	11118
5	-
5	11122
5	11114
6	-
7	11123
8	-

[prat1507]

hi

Maybe this

If([Defect Code]<>'-',count(distinct(ID)))

[DipeshVadgama]

Thanks Pratyush,

But is not working 😞

[sunny_talwar]

May be this

Count(DISTINCT {<ID = {"=Count([Defect Code]) > 0"}>} ID)

or

Count(DISTINCT {<[Defect Code] = {'*'}>} ID)

[DipeshVadgama]

Thanks Sunny,

Count(DISTINCT {<[Defect Code] = {'*'}>} ID)

This works perfect.

Appreciate if you can explain this formula to me. DISTINCT {<[Defect Code] = {'*'}>}

[sunny_talwar]

The expression is just distinct counting IDs where Defect Code is not null ({<[Defect Code] = {'*'}>})

[DipeshVadgama]

Great Thanks for you help.

[sunny_talwar]

No problem at all