- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

AVERAGEX ignores blank values. See the link below for an example that illustrates this behavior.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

AVERAGEX ignores blank values. See the link below for an example that illustrates this behavior.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
11-27-2023 11:47 AM | |||
10-14-2024 03:28 PM | |||
08-08-2024 12:28 PM | |||
11-23-2022 05:08 PM | |||
06-18-2024 01:55 PM |