Forum Discussion
Matrix Visualization - Changing the Value displayed based on drill down level
Hi scpm,
I believe that you need something in the line of this article to this article from @marcorusso, in this article the hierarchy are calculated based on the path that each hierarchy level has then based on that we do a lookup of the previous level.
The several levels of hierarchy are calculated in hidden columns then we use to make the final calculations based on the measures we need.
I have made a similar example for another post please check the PBIX file attach this one is making count but measures can be changed to sum or other things.
Check the article in detail and the PBIX file attach with the solution.
Regards,
MFelix
Hi scpm,
I believe that you need something in the line of this article to this article from @marcorusso, in this article the hierarchy are calculated based on the path that each hierarchy level has then based on that we do a lookup of the previous level.
The several levels of hierarchy are calculated in hidden columns then we use to make the final calculations based on the measures we need.
I have made a similar example for another post please check the PBIX file attach this one is making count but measures can be changed to sum or other things.
Check the article in detail and the PBIX file attach with the solution.
Regards,
MFelix
Thanks for the quick reply MFelix .
If I'm understanding the solution correctly, I would need to build a new table that is in the form of:
ID Name ParentID [Other attributes I may want]
The new table combines the Parents and Children into the same table, and leaves the ParentID blank for any of the Parent items. At which point, I can base everything on the Hierarchy pbix from your last message. Or did I misunderstand? Let me give this a try and see how it works. Thanks!