Forum Discussion
Dynamic counting for multiple hierarchies in Matrix Visual
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.
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.
