How to calculate a unique (or distinct) count using DAX
Published 11 days ago • 1 min read
How to use DAX to count up something (and ignore duplicate values.)
Hey hey Reader,
A few months ago I posted about the DAX COUNT function (which counts things, because #obvi) ... but it counts EVERYTHING, including duplicate values.
So, thankfully there's the DISTINCTCOUNT function, so you can count something up and ignore all those duplicates. VERY handy if you have a large dataset and need to use an accurate count of something (ID #s, departments, clients, etc etc etc) in some DAX. DAX: DISTINCT COUNT
Not loving How To Use Power BI in your inbox anymore? Unsubscribe here.
(because you should only get these emails if you love them and find them useful!)
I run friendly and informative Beginner and Advanced Power BI workshops. Get started (or level up if you already know the basics) so you can start reporting insights from your data ASAP! Hit the reply button on this email and let's chat.
After 7+ years of using Power BI daily, I've come across (and sworn at) a LOT of error messages, things that don't make sense, and other challenges. You don't have to go through it all too... you can get me to help you through the challenges. Don't spend hours/days/weeks being frustrated... I've already gone through that FOR you. Talk to me. I can help.