Forum Discussion
Avg Gift measure replace NaN
Really easy one I am sure but any help on this would be greatly appriciated. I have a basic measure calculating average gift based off 2 other mesaures:
madmanmark198
You can use the following DAX measure:Avg Gift = DIVIDE([Received + Balance],[Distinctcount Donors],0)Please let me know if this didn't work.
4 Replies
- rajulshahResident Rockstar
madmanmark198
You can use the following DAX measure:Avg Gift = DIVIDE([Received + Balance],[Distinctcount Donors],0)Please let me know if this didn't work.
- madmanmark198Frequent Visitor
Brillaint thank you so much! Nice and easy! Sometimes it just takes another set of eyes to figure it out.
- Robert_AndersonNew Member
Good point on handling NaN values when calculating the Avg Gift measure it really helps keep the results accurate and readable. I’ve seen similar cases where setting a default or filtering nulls improves reporting clarity. For anyone gathering user-driven insights, resources like Auto Zone Feedbacks can also offer useful context on interpreting aggregated responses. Overall, a clean approach to missing data makes analysis much more reliable.
- Brian_Scott12New Member
This is a useful approach for handling missing values in an Avg Gift measure, especially when you want cleaner visuals and more reliable insights. Replacing NaN thoughtfully can really improve how trends are interpreted. I’ve seen similar techniques discussed alongside Sprouts Market Insights when working with survey-based metrics. Overall, this kind of adjustment makes reports easier to read and more actionable for decision-making.