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 on mentioned above 3 columns so in the calcuation only 123 should be considered . total result should be =118+123+129+166+250 .Hope you got it

 

Need Help

8 Replies

  • 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

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi Anonymous,

     

    I made one sample based on your sample data. We can create a calculated table.

     

    Table = SUMMARIZE(Table1,Table1[FEEDYARD],Table1[lot_id],Table1[pen_id],Table1[VCI_RECEIVED_Head])

     

    Also please find the pbix as attached.

     

    Regards,

    Frank