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 value.  Bascially, subtracting the Purity value from the Total

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

 

 

 

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.

2 Replies

  • 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.

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

    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.