cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stroopwafels
Regular Visitor

How to calculate AVERAGE

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:Helpplease.png

Thanks!! 

 

 

 

2 REPLIES 2
v-huizhn-msft
Microsoft
Microsoft

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
Super User
Super User

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

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors