Avg Gift measure replace NaN

[madmanmark198]

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] / [Distinctcount Donors]

Some of the rows in my table have no data yet so I have £0 for Recieved + Balance  and 0 Distinct Donors.  All works fine when there is data but for those rows where there isnt any data yet it returns a NaN.  What I would like it to do is to show 0 or n/a in place of Nan?

[rajulshah · Accepted solution]

@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. 

[madmanmark198]

Brillaint thank you so much!  Nice and easy!  Sometimes it just takes another set of eyes to figure it out.