Distinct Count help needed

I have now managed to get the distinct count of sites with an ACTIVE program status using the following.

Active Sites = CALCULATE(DISTINCTCOUNT('Programs' [Site Name]), 'Programs' [Program Status] = "ACTIVE")

But struggling to work out the dax to included all of the three program status together

Hi TonyAshton ,

You can use the following DAX formula:

Count Sites =
CALCULATE (
    DISTINCTCOUNT ( 'Programs'[Site Name] ),
    'Programs'[Program Status] IN { "ACTIVE", "COMPLETED", "REGISTERATIONS CLOSED" }
)

Best Regards,

Neeko Tang

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