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 matrix, relationships.

 

Please help me out from this issue

Thanks,

 

Thanks

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

7 Replies

  • 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

      • 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?