topic Re: Dynamic counting for multiple hierarchies in Matrix Visual in DAX Commands and Tips

Dynamic counting for multiple hierarchies in Matrix Visual

MareRuiz — Tue, 22 Jul 2025 12:38:47 GMT

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!

Re: Dynamic counting for multiple hierarchies in Matrix Visual

FBergamaschi — Tue, 22 Jul 2025 13:29:12 GMT

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

Re: Dynamic counting for multiple hierarchies in Matrix Visual

v-saisrao-msft — Wed, 23 Jul 2025 09:26:04 GMT

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.

Re: Dynamic counting for multiple hierarchies in Matrix Visual

MareRuiz — Tue, 09 Sep 2025 17:25:02 GMT

My request is unsolved. But I rather mark my response as a solution, than letting something that was not a solution marked as such. I did answered on the 23 of August letting them know that the issue was not solved and that the propossed solutions did not worked. If anyone can help solve this issue, I'll be grateful.

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? -- I tried with visual calculations, but they can't be used to filter, so it doesn't fix my issue either.

Re: Dynamic counting for multiple hierarchies in Matrix Visual

v-saisrao-msft — Mon, 28 Jul 2025 04:11:21 GMT

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.

Re: Dynamic counting for multiple hierarchies in Matrix Visual

v-saisrao-msft — Thu, 31 Jul 2025 04:28:04 GMT

Hi MareRuiz,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

Re: Dynamic counting for multiple hierarchies in Matrix Visual

v-saisrao-msft — Mon, 04 Aug 2025 03:35:53 GMT

Hi MareRuiz.,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

Re: Dynamic counting for multiple hierarchies in Matrix Visual

v-saisrao-msft — Thu, 07 Aug 2025 05:18:44 GMT

Hi MareRuiz,

We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.

Thank you.

Re: Dynamic counting for multiple hierarchies in Matrix Visual

MareRuiz — Tue, 09 Sep 2025 17:19:55 GMT

This is not a solution to my problem, please unmark it.

Re: Dynamic counting for multiple hierarchies in Matrix Visual

MareRuiz — Tue, 09 Sep 2025 17:21:26 GMT

I review it, and I answered, I don't understand why you marked my problem as solved when it is not solved.

Re: Dynamic counting for multiple hierarchies in Matrix Visual

MareRuiz — Tue, 09 Sep 2025 17:35:50 GMT

My conclussion from this is that there's not a solution to the problem.

With Visual calculation, it can be done, but then it's impossible to filter.

With normal DAX the filter context can't handle the different hierarchies.

This is just a limitation in the Matrix visual that should be addressed by the Microsoft team.

Impossible to solve.

Thank you for trying.

Re: Dynamic counting for multiple hierarchies in Matrix Visual

v-saisrao-msft — Wed, 10 Sep 2025 05:51:12 GMT

Hi MareRuiz,

Thank you for your explanation. If you would like this issue to be resolved, please submit the idea in the ideas forum. If it receives enough votes, Microsoft may consider it for a future release.

Fabric Ideas - Microsoft Fabric Community

Thank you.