Forum Discussion

Stroopwafels's avatar
Stroopwafels
Regular Visitor
8 years ago

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!!