Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

help needed

  I need to calculate the sum of VCI_RECEIVED_Head on group by feedyard ,pen_id and lot_id .can you help me here . even if the rationid is different but for example in below row2 and row3 are unique...
Need Help
Arentir's avatar
Arentir
Resolver III
7 years ago

Hi Anonymous,

My understanding is that you want to have the sum of the unique value of VCI Received_Head group by Lot_Id and Pen_ID.

 

This measure should work for you.

 

Measure =
SUMX (
    SUMMARIZE ( Table, Table[LOT_ID], Table[PEN_ID], Table[VCI_Received_Head] ),
    Table[VCI_Received_Head]
)

 

Let me know if it works

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I NEED ONE MORE COLUMN ON GROUP BY THAT IS FEEDYARD COLUMN ALSO .

    • Arentir's avatar
      Arentir
      Resolver III
      7 years ago

      then add it to the summarize function and you re good to go

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        i am getting error saying sumx should use the expression . VCI_RECEIVED_Head not being determined . can you please check once