Current row column value

[Anonymous]

Hi !

I'm creating a calculated column. For each calculated row of the column, I need the value of another column of the table, on the same row.

I called this value _weight and I calculated like this :

VAR _weight = CALCULATE(ShipDetails[NET_WEIGHT_LBS])

I thought this would work since the CALCULATE function generates a row context (?) but an error message is shown, saying that it cannot find a unique value for the ShipDetails[NET_WEIGHT_LBS] column.

I feel like this should be very easy but I don't know why it doesn't work or what I should do.

Please help me !

Thank you.

[Pragati11]

Hi @Anonymous ,

You have to use an aggregation function in your DAX like SUM, AVERAGE, etc.

Something like this:

VAR _weight = CALCULATE(SUM(ShipDetails[NET_WEIGHT_LBS]))

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[harshnathani · Accepted solution]

Hi @Anonymous ,

You can just use

var _weight = ShipDetails[NET_WEIGHT_LBS]

You can have a look at this video to understand more on Context Transition.

https://www.youtube.com/watch?v=03E0f-RyRn4

Regards,

Harsh Nathani

[Anonymous]

Thank you very much @harshnathani !

Regards,

Marion