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: