Forum Discussion
Dynamic counting for multiple hierarchies in Matrix Visual
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!
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.
11 Replies
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.
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.
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
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.
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.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.
Hi MareRuiz.,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
