Do iterators ignore blank values?

[tizzlelizzle]

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?

[DataInsights · Accepted solution]

@tizzlelizzle,

AVERAGEX ignores blank values. See the link below for an example that illustrates this behavior.

https://dax.guide/averagex/