Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello, I have a data model with three tables: Parent, Child (link to Parent via e one to many relation) and Grandchild (linked to Child via a one to many relation).
Parent table:
Child table:
Grandchild table:
I want to visualize all combinations of Parents and Childs + number of GrandChilds (from the perspective of the Parent).
Measure I'm using:
@dieterbe_vdb , Using power query merge add parent Id to Grandchild table and then join it with parent and child directly, then +0 should work better
Merge: https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Should be very similar to Power BI Items/Categories not sold to the customers: https://youtu.be/AbuKvAnicwo
Many thanks for your answer!
I agree that joining tables will do the job.
My question remains: why isn't the relationship / filter working in my example => so why does PowerBI shows combinations which aren't possible at all? It is known (from the relations) that child BA can't be a child of parent A => how can I avoid Power BI to show this combination in my table (supposing that I'm working with different tables and relationships between these tables)?
User | Count |
---|---|
136 | |
70 | |
69 | |
54 | |
53 |
User | Count |
---|---|
207 | |
94 | |
64 | |
61 | |
57 |