Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II
Helper II

Manage parent-child relations in PBI visuals

Hello community,


I wonder if it was possible to get Power BI manage parent-child relation.


In my data model, I have amounts that accounted with a Project-activity code. Each project-activity code is a part of a project code.


-Parents codes are the project codes : P1, P2 ...

-Children codes are the project-activity codes

-The activities P1-A and P1-B are a part of the P1 project

-The activities P2-A and P2-B are a part of the P2 project ...

-Each Project-activity amount is accounted with a field : classification test ("Matérials" or "Calculate")



Example of issue :


P1-A =10 (Materials) ; P1-C =20 (Calculate)

P3-A =15 (Calculate) ; P3-B = 20 (Materials)

The addition for the project P1 is 30, P3 it's 35. And for Materials the result is 30, for Calculate it's 35. Ok for that.


But if I want to add 50 directly by the the parent code (P1 for example), the result by project will be right (P1=20+10+50=70). But the result by classification test is wrong. The PBI mesure result is 80 for Materials (20+10+50) and 85 for Calculate (20+15+50).


How to get PBI share (and not double) the add of 50 between the classification test field ?


I know the difficult is because the add has to be done by project code (parent) where as the data model has amounts accounted by children code (project-ctivities code). But when I have to add 50 (by project code) I can't specify the classification test.


Thanks if someone can understand the problem and have and Idea for a fonction or mesures.





Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors