Forum Discussion
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...
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
You can use the following DAX measure:
Avg Gift = DIVIDE([Received + Balance],[Distinctcount Donors],0)Please let me know if this didn't work.
Brillaint thank you so much! Nice and easy! Sometimes it just takes another set of eyes to figure it out.