Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

View all the Fabric Data Days sessions on demand. View schedule

Reply
CubsFan
New Member

Distinct count of hierarchy categories possible?

I am having trouble finding a solution to my need.  I need to produce a card visualization (or card-like) that presents the disctinct count of elements in a category with the ability to drill through to the next level and provide that level's distinct count of elements.  Hypothetical data & sample below.  How do I present with drill-through capability the distinct count of Categories (2); Products (4); and Compenents (7)?

 

Thank you!

 

CategoryProductComponent
ToyWagonWheels
ToyWagonSheet Metal
ToyWagonPaint
ToyFrisbeeMolded plastic
ToyFrisbeePaint
KitchenSinkGranite
KitchenToasterSheet Metal
KitchenToasterHeating Element
KitchenToasterDiode
1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

So, I don't believe you will get there with a card visualization, no drill down. And I assume you mean drill down, not drill through, because that has a very specific connotation in Power BI and I don't think it is what you want, but might be a solution.

 

So, what you are going for is something like a single visual that shows

 

Elements 2

 

and them drilling down would be:

 

Elements 4

 

and then drilling down would be:

 

Elements 7

 

 

Curious as to what exactly you are going for here in terms of the interface. Something that *may* give you some ideas is this Quick Measure:

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Community Champion
Community Champion

So, I don't believe you will get there with a card visualization, no drill down. And I assume you mean drill down, not drill through, because that has a very specific connotation in Power BI and I don't think it is what you want, but might be a solution.

 

So, what you are going for is something like a single visual that shows

 

Elements 2

 

and them drilling down would be:

 

Elements 4

 

and then drilling down would be:

 

Elements 7

 

 

Curious as to what exactly you are going for here in terms of the interface. Something that *may* give you some ideas is this Quick Measure:

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors