Forum Discussion
Solved
Relational schemmes with 2 tables
Hello everyone. Some time ago I made a post about data relationships for a hierarchical schema: https://community.powerbi.com/t5/Translated-Spanish-Desktop/Esquema-jerarquico-cuenta-incomplet...
The key to working with hierarchies in Power BI is flattening them in one table. The fact that in a table you'll have many repetitions is a good thing in the dimensional data modeling world. Your worry is totally ill-founded. You can read about how to handle parent-child hierarchies here: https://www.daxpatterns.com/parent-child-hierarchies/
What is the visual you are trying to create? Can you provide a sample depiction?
I may use matrix or hierarchy schemme or bar graph, also filtering by a common value. Listing the level 1 users to compare the total value for each one and drill down to level 2 users and so on.