You’re Using DISTINCTCOUNT WRONG in Power BI – Fix It with This DAX Trick!
Pragmatic Works
0:00 / 0:00
You’re Using DISTINCTCOUNT WRONG in Power BI – Fix It with This DAX Trick!
5 185 просмотров · 2 года назад
Pragmatic Works
341 тыс. подписчиков
5 185 просмотров · 2 года назад
This video delves into the intricacies of creating the logic to perform a DistinctX in DAX. Mastering data manipulation with DAX is a game-changer for your analytical prowess, and this tutorial offers a detailed walkthrough for integrating a DistinctX into your data analyses.
👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt
👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can visit https://prag.works/MITCHELL40 for 40% off On-Demand Learning!
🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/
Let's connect:
✔️Discord: https://prag.works/yt-discord
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#pragmaticworks #powerbi #dax #fyp #businessintelligence #powerbitips #foryou
0:00 - Introduction
0:27 - Overview of the problem
3:17 - Creating a new column
5:12 - Using CONCATENATEX function
8:00 - Applying DISTINCT function
12:13 - Alternative methods
15:23 - Conclusion and next steps