Average Calculation by distinct count

[jeffreykeryk]

Average = Sum / Count

For a pivot visualization, can I extend the Values summerization to Average = Sum / Distinct Count?

Thanks in advance!

Jeff Keryk

[MattAllington · Accepted solution]

yes, just write a custom measure as follows

myAverage = divide(sum(table[Column]),distinctcount(table[Column]))

[jeffreykeryk]

Hey Matt - It's funny... I have been doing DAX measures in Power Pivot for some time. With PBI, I am working with a new tool and I seem to forget what I already know!

Thanks for your help; it was perfect.

Jeff Keryk