Forum Discussion

mikesfagan's avatar
mikesfagan
New Member
6 years ago
Solved

Use values from other rows to execute a custom calculation

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...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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.

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

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.