help needed

[Anonymous]

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 · Accepted solution]

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