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

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