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.
What is the difference between DistinctCount and DistinctCountNoBlank.
Solved! Go to Solution.
@Rsing ,
DISTINCTCOUNT: Counts all distinct values in a column, including blanks.
DISTINCTCOUNTNOBLANK: Counts all distinct values in a column, excluding blanks.
@Rsing ,
DISTINCTCOUNT: Counts all distinct values in a column, including blanks.
DISTINCTCOUNTNOBLANK: Counts all distinct values in a column, excluding blanks.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
80 | |
60 | |
60 | |
58 |
User | Count |
---|---|
155 | |
119 | |
104 | |
78 | |
71 |