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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
40 | |
21 | |
20 | |
13 |
User | Count |
---|---|
125 | |
42 | |
39 | |
27 | |
24 |