How to calculate AVERAGE

[Stroopwafels]

Hello guys, 

I need your help with calculating the an average from a measure. 

In this measure, there is a formula which gives a certain result, this table is called Amount. 

I tried the formula SUM(amount)/ distinctcount(amount) but this isn't working. 

Does anyone have an idea how to resolve this? 

See the attached table:

Thanks!! 

[v-huizhn-msft]

Hi @Stroopwafels,

In your screenshot, the column "What I want" and "Amount" are same, what's the calculation rules for data, please clear up your requirement.

Best Regards,
Angelia

[Greg_Deckler]

I'm not exactly sure what you are asking, but check this post and see if it helps:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376