Dynamic counting for multiple hierarchies in Matri...

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?

v-saisrao-msft

Hi @MareRuiz,

There are only two rows with that combination, so the sum will appear in the totals. As a result, we won't be able to display the row count based on the drill down.

Thank you.