Dynamic counting for multiple hierarchies in Matrix Visual

[MareRuiz]

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!

[v-saisrao-msft]

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.

[MareRuiz]

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?

[FBergamaschi]

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