Matrix with same values across all rows

[Mani_1]

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

[mlsx4]

Hi @Mani_1 

I don't know which measure are you using, but you should use a iterative formula: SUMX, AVERAGEX or something similar

[Mani_1]

I'm not using any measure here

[mlsx4]

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?

[Mani_1]

Hi @mlsx4 ,

Please find the dummy data in screenshot, here count of ID is shipment, two tables are connected by ID field.

[mlsx4]

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

[Mani_1]

Hi @mlsx4 ,

yes, but it should show the shipment count right??

[mlsx4 · Accepted solution]

Hi @Mani_1 

I have used your data:

Relate the ID:

And calculate shipment

Shipment = COUNT('001_sub'[ID])

It's working fine