Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Yannick
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
96 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |