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

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!


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

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


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #DISTINCTCOUNT#GuyInACube

[amg]

HOLY COW I have been struggling with this issue-- I would have never figured out this solution. Thank you Patrick & Adam (and Phil!!) for sharing your brilliance! Super stoked to try this out.

[andyparkerson]

Now I have to go look up aggregation tables in PowerBI. Always more to learn!

[Szczotii]

Have to admit, never heard of aggregations in Power BI, but I'm diving into the topic right after the video. Thanks Patrick for sharing the knowledge 🙌

[tareksalha]

I really like the narrative way, how the story unfolds 🤩
Patrick, great solution to trick the engine! 👍

[bigdave]

Absolutely incredible solution. Insane amazing work guys, thank you!

[ChrisWagnerDatagod]

You solved it!!!! Thanks Adam and Patrick!

[thedavidgzz]

intelligent way of resolving things, thanks!

[htctihp]

I made it sub category as distinct count and try to apply on the filter but couldn't apply so instead of this function which calculation should I use for subcategory count but no aggregate values

[amritpriadarsy]

That's great and amazing solution.
Thanks!!

[BlackDragon-gdio]

So, What is inside of that FusionKey column?
Is that only filled with 1?
or Is that a duplicate of customer key column?

[rapatel]

"Q" does this work if you have to do two distinct counts on the same aggregated dataset?

[MukeshKumar-vtig]

Wow that’s incredible but need to request someone who has access to the source then only this solution possible ?

[VishnuPriya-ngwk]

No idea about Fusion key. Can you provide background about Fusion key?

[lucasshipsides]

when should fusion key be 1 in the source and when should it be another value?

[vinaybk]

Heyy, please make a video on how to connect AZURE MIGRATE API to POWER BI

[muchvqq]

For the benefit of all future people pulling their hair out and searching for the error message "multiple aggregations not supported by Import when distinct count is present", this is the video for you!

[justapasserby]

Hey, how do I set a default bookmark per page? Thanks for your work! I learned PBI from your channel

[micahdail]

I don't deserve you, Patrick. Or Phil.

[matthiask]

confusing & selling a workaround as a feature

[dariuszspiewak]

Hm... It's a real pity that one has to resort to such stunts to achieve something that should work correctly out of the box. Microsoft.