Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

 

 

  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Anonymous,

     

    It seems that you want to calculate the sum of VCI_RECEIVED by distinct feedyard ,pen_id and lot_id.

     

    You could create the formulas below.

     

    1. Create the calcuated table to get the distinct values.

     

     

    Table =
SUMMARIZE (
    'Table1',
    'Table1'[VCI_RECEIVED],
    "Fee", DISTINCT ( 'Table1'[Feedyard] ),
    "Lot", DISTINCT ( 'Table1'[LOT_ID] ),
    "Pen", DISTINCT ( 'Table1'[PEN_ID] )
)

    2. Then you could create the measure to calculate the sum of VCI_RECEIVED.

     

     

     

    Measure = CALCULATE(SUM('Table'[VCI_RECEIVED]))

     

    Here should be your desired output.

     

    Best  Regards,

    Cherry

1 Reply

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    Hi Anonymous,

     

    It seems that you want to calculate the sum of VCI_RECEIVED by distinct feedyard ,pen_id and lot_id.

     

    You could create the formulas below.

     

    1. Create the calcuated table to get the distinct values.

     

     

    Table =
SUMMARIZE (
    'Table1',
    'Table1'[VCI_RECEIVED],
    "Fee", DISTINCT ( 'Table1'[Feedyard] ),
    "Lot", DISTINCT ( 'Table1'[LOT_ID] ),
    "Pen", DISTINCT ( 'Table1'[PEN_ID] )
)

    2. Then you could create the measure to calculate the sum of VCI_RECEIVED.

     

     

     

    Measure = CALCULATE(SUM('Table'[VCI_RECEIVED]))

     

    Here should be your desired output.

     

    Best  Regards,

    Cherry