Use values from other rows to execute a custom calculation

[mikesfagan]

I'm trying to write a custom calculation in the Total Protein advancedcalcs field, where i can use the Enteredvalue value of the Purity result to calculate a new Protein result fo reach unique keyid1 value.  Bascially, subtracting the Purity value from the Total

Protein value.  What's the best way to do this?

[v-lid-msft]

Hi @mikesfagan ,

How about the result after you follow the suggestions mentioned in my original post?

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lid-msft · Accepted solution]

Hi @mikesfagan ,

We can use the following measure to meet your requirement:

advancedcal = 
AVERAGEX (
    FILTER ( ALL ( 'Table' ), [keyid1] IN FILTERS ( 'Table'[keyid1] ) ),
    [enteredvalue]
)

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.