Forum Discussion

Mani_1's avatar
Mani_1
Frequent Visitor
3 years ago
Solved

Matrix with same values across all rows

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 ...
Need Help
  • mlsx4's avatar
    mlsx4
    3 years ago

    Hi Mani_1 

     

    I have used your data:

     

    Relate the ID:

    And calculate shipment

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

     

    It's working fine

mlsx4's avatar
mlsx4
Memorable Member
3 years ago

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's avatar
Mani_1
Frequent Visitor
3 years ago

I'm not using any measure here

  • mlsx4's avatar
    mlsx4
    Memorable Member
    3 years ago

    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's avatar
      Mani_1
      Frequent Visitor
      3 years ago

      Hi mlsx4 ,

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

      • mlsx4's avatar
        mlsx4
        Memorable Member
        3 years ago

        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