Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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.
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.
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
User | Count |
---|---|
47 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |