Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???

Posted on by Annie D

Using Aggregations in Power BI? Have some DISTINCTCOUNT in your measures? Wondering why the queries are slow and not hitting the aggs? Patrick shows you what is going on! Get ready for some DAX fusion!

DAX Fusion: https://dax.tips/2019/08/05/dax-fusion/

Aggregations Documentation: https://docs.microsoft.com/power-bi/transform-model/aggregations-advanced

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #DISTINCTCOUNT#GuyInACube

Guy in a CubeWed, May 11, 2022 6:39pm