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

Mani_1's avatar
Mani_1
Frequent Visitor
3 years ago

Hi mlsx4 ,

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

 

mlsx4's avatar
mlsx4
Memorable Member
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