Forum Discussion

3cdoug's avatar
3cdoug
Regular Visitor
3 years ago
Solved

Reference instances within a table

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?
 
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.