topic Re: Distinct Count help needed in DAX Commands and Tips

Distinct Count help needed

TonyAshton — Sun, 05 May 2024 04:22:59 GMT

I am looking for some help on how to create a dax measure to return the distinct count of names from a column based on the multiple results from another column.

Column A: Site Name

Column B: Program Status

Column B has a number of different Program Status. I am only wanting the distinct count of Site Names if it has any of the following Program Stauts; "COMPLETED", "ACTIVE", "REGISTERATIONS CLOSED".

if anybody can help it would be greatly appreciated.

Re: Distinct Count help needed

TonyAshton — Sun, 05 May 2024 05:11:59 GMT

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

Re: Distinct Count help needed

Anonymous — Tue, 07 May 2024 01:41:46 GMT

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.