Reference instances within a table

3cdoug — Tue, 30 May 2023 18:18:51 GMT

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?

Re: Reference instances within a table

Anonymous — Thu, 01 Jun 2023 09:24:37 GMT

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.