Different total result with Averagex

[MacarenaGB]

Hi everyone!

I am trying to get get a total of a measure which should make the average according to "Descripción" column. 

I need that the result sum 17,27 instead of 5,73.

Can anyone help me? TIA!!! 🙂

[amitchandak · Accepted solution]

@MacarenaGB , Try a measure like

Measure = Sumx(VALUES('Avg For Csv'[Descripción]), CALCULATE(AVERAGE('Avg For Csv'[Total])))

[amitchandak]

@MacarenaGB , what is logic of 17.27

May be Divide([Total], count(Table[Description])

or

Divide([Total], distinctcount(Table[Description]))

Please share logic and Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[MacarenaGB]

Hello

I tried it but it doesn't work:
Let me attach the table

Descripción,Total
Gasto A,10
Gasto A,12
Gasto A,12
Gasto A,14
Gasto A,10
Gasto B,3
Gasto B,3
Gasto B,3
Gasto B,3
Gasto C,2
Gasto C,3
Gasto C,2
Gasto C,3
Gasto C,3
Gasto C,3

Thanks!