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!

[MareRuiz]

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.

[v-saisrao-msft]

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.

[v-saisrao-msft]

Hi @MareRuiz.,

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

Thank you.

[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 · Accepted solution]

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.

[v-saisrao-msft]

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.

[v-saisrao-msft]

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.

[MareRuiz]

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

[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.

[MareRuiz]

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

[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