Forum Discussion
Stemar_Aubert
Resolver I
Resolver IAVERAGEX unexpected behavior.
Hello, I have an issue with AVERAGEX. Using it with a simple table created for testing purposes, I get the following and expected results: Where "at measure" is a simple SUMX(NUMBER 1 * NUMB...
v-jingzhang
Community Support
Community Support
If your expected result is the arithmetic mean of all the measure values displayed in the column, you could try parry2k 's solution.
Otherwise if your expected result is not that, it's difficult to tell which would be the cause as we don't know how complex the measure is. I think the logic in the expression is also a possible cause besides the context. You could try calculating the numerator and denominator separately to check whether they are calculated correctly to get what you expect.
Kindly let me know if this helps.
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.