Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
I am trying to get the contribution of shipments by sub companies which are under main companies, but i get the same values across all rows. how to solve this problem.I have encosed pictures of matrix, relationships.
Please help me out from this issue
Thanks,
Thanks
Solved! Go to Solution.
Hi @Mani_1
I have used your data:
Relate the ID:
And calculate shipment
Shipment = COUNT('001_sub'[ID])
It's working fine
Hi @Mani_1
I don't know which measure are you using, but you should use a iterative formula: SUMX, AVERAGEX or something similar
I'm not using any measure here
How is your data structured? I mean...
Shipments, weight, etc... are fields of Main (and you have some ID to relate with subcompany) or how?
Can you provide some dummy data here?
Hi @mlsx4 ,
Please find the dummy data in screenshot, here count of ID is shipment, two tables are connected by ID field.
Hi @Mani_1
But according to your relationship, company name is never duplicated (in dummy data it is), isn't it?
Anyway, if weight and volume is only in main, it will be difficult to separate by subcompany. It would always take the total
Hi @Mani_1
I have used your data:
Relate the ID:
And calculate shipment
Shipment = COUNT('001_sub'[ID])
It's working fine
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
56 | |
38 | |
34 |
User | Count |
---|---|
99 | |
56 | |
51 | |
44 | |
40 |