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-frfei-msft]

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

[Arentir]

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]

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

[Arentir]

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

[Anonymous]

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

[v-frfei-msft]

Hi @Anonymous,

Could you please share your pbix to me?

Regards.

Frank

[Anonymous]

can you guide me on how to attach the PBIX file ?

[v-frfei-msft]

Hi @Anonymous,

Just upload your file to dropbox and share the link here.

Regards,

Frank