Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi community,
I have challenge:
I have a matrix with 5 hierarchies: Manufacturer, Signature, Brand, Sub_Brand, Franchise.
That look like this:
And I want to count the rows occupied by each, something like this in a dynamic way:
Or another option is to have the total rows that belong to each manufacturer as a rolling total like this:
It has to be dynamic to the order of the Matrix visual, so if rows change their order, then the numbers should adjust:
Thank you in advance for your help!
Hi @MareRuiz,
Thank you for reaching out to the Microsoft fabric community forum.
Thank you @FBergamaschi, for you insights.
I have recreated your scenario using sample data on my own. Please find the attached PBIX file for your reference.
If you need any assistance, please let us know.
I hope this information is helpful.
Thank you.
Hi @v-saisrao-msft ,
Thank you for trying, however, the solution is not exactly what I'm looking for. I need something a little bit different:
The pink solution is a running total of the lines showing, at Manufacturer level.
The Red one is an enumeration of the lines.
@FBergamaschi I'll try with visual calculations. Can I use them to filter?
this is a prefect example to try for a visual calculation
Use CALCULATE and COUNTROWS together with the EXPAND/COLLAPSE functions
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Documentation is here
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-visual-calculations-overview
If this helped, please consider giving kudos and mark as a solution
@mein replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
6 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |