Forum Discussion
Stroopwafels
8 years agoRegular 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:
Thanks!!
2 Replies
- Greg_Deckler
Community Champion
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
- v-huizhn-msft
Microsoft Employee
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