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.
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.
This is not a solution to my problem, please unmark it.
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.
I review it, and I answered, I don't understand why you marked my problem as solved when it is not solved.
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.