Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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.
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.
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.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |