Reference instances within a table

[3cdoug]

Cert 1 = IF('Submitted Certs'[Cert] = "Cert 1", DISTINCTCOUNT('Submitted Certs'[Cert]))

I want to calculate all the instances in which "Cert 1" occurs, i keep getting the wrong number, any help?

[v-rzhou-msft · Accepted solution]

Hi @3cdoug ,

 I think you can add filter in your code.

Count =
CALCULATE (
    DISTINCTCOUNT ( 'Submitted Certs'[Cert] ),
    FILTER ( 'Submitted Certs', 'Submitted Certs'[Cert] = "Cert 1" )
)

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.