natural logarithm as a measure

[ponchibonosrzt]

Hi everybody

I have a table with number of records  of species "Cuenta" in a sample. I want to aplicate the natural logarithm (LN) to each of them and I use this DAX: 

Medida = LN(SUM(Hoja1[cuenta]))

I insert "Medida" in a matrix visualization, but the problem is the Total value is not the sum of the individual values of "Medida", instead is the calculation of LN for the Total of the column "Cuenta" =(LN(40)). 

How can I make the total shows the sum of all “Measure” values? (0.00+0.69+0.00+1.10+3.04+0.69+2.20+0.00 = 7.73)

Thanks in advance

[Ahmedx · Accepted solution]

write another measure like this

=SUMX(VALUES('yourtable'[especie]),[Medida])

[AmiraBedh]

Try the following :

Medida = 
IF(
    HASONEVALUE(Hoja1[SpeciesColumn]),  -
    LN(SUM(Hoja1[cuenta])), 
    SUMX(VALUES(Hoja1[SpeciesColumn]), LN(SUM(Hoja1[cuenta])))  
)