Forum Discussion
Solved
Do iterators ignore blank values?
I have the following two measures in a report:
1. Average growth using DIVIDE and DISTINCTCOUNT
2. Average growth 2 using AVERAGEX
Average growth 2 is higher than Average growth as it is dividing the total growth by 4 instead of 5 - which makes me think that iterators (or at the very least, AVERAGEX), ignore blank values. Is this understanding correct?
AVERAGEX ignores blank values. See the link below for an example that illustrates this behavior.
1 Reply
- DataInsights
Super User
AVERAGEX ignores blank values. See the link below for an example that illustrates this behavior.