Forum Discussion

madmanmark198's avatar
madmanmark198
Frequent Visitor
3 years ago
Solved

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:   Avg Gift = [Received + Balance] / [Disti...
Need Help
  • rajulshah's avatar
    rajulshah
    3 years ago

    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. 

Robert_Anderson's avatar
Robert_Anderson
New Member
8 months ago

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.