Forum Discussion
Measure variable not working as expected
Hi mgrayTCB ,
For _NRRI YOY Ave % 1step, it defines a threshold _threshold and then uses the SUMMARIZE and AVERAGEX functions combined with an if statement to conditionally compute the average based on the threshold. This function calculates the annual average within the threshold.
For _NRRI YOY Ave % 2Steps, which does not have any constraints, the AVERAGEX function is used directly to compute the annual average of the attribute name.
In summary, the first function excludes certain values by introducing conditional logic, possibly to deal with outliers or specific data points. The second function, on the other hand, calculates the average of all given conditions. This difference in calculation methods may result in different final averages.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am not following your argment. Unless I am missing something both the 1step and the 2steps measures work off the same logic in NRRI YOY%. In the 1step measure I think I am just taking the last variable and _AverageWithinThreshold and avering it by property. In the 2step measure I am just refereincing the NRRI YOY% measure and doing the same thing that the result is doing in the 1Step measure but ending up with different answers in the total row and cant figure out why.
Here is a simpler example of the same problem (or more likely something fundimental that I am missing). In the table below 47.5% is the average of the average of each property and the answer I am trying to get without writing two measures and having the second one reference the first one. What am I mssing?
-----------
