Count cells, add it in another cell and then make an average per customer

[ivancespedesl]

Hi,

Im trying to get an average of products per clients. I have the following formula

Average products=

VAR Count Cantidad productos = COUNTA('blabla'[Cant_CA]) + COUNTA('blabla'[Cant_CC]) + COUNTA('blabla'[Cant_TC]) + COUNTA('blabla'[Cant_CD])

return

calculate(average(count_cantidad_productos),filter('table'[clients]))

I had something like but it didnt work.

Please help me.

Regards,

IC

[v-chuncz-msft]

@ivancespedesl 

You may try AVERAGEX.

https://community.powerbi.com/t5/Desktop/Average-of-a-measure-for-each-value-of-the-years/m-p/312310...

[ivancespedesl]

@v-chuncz-msft ,

I tried this but it still doesnt work, I really dont understand why. I even changed counta to countax in order to get the row logic. However, it still gives me the average result as the sum of all the products. Maybe I didnt explain myself well enough. This should be the average per customer, so maybe my formula doesnt explain that I want to get the amount per client. Once again, my formula:

Promedio Productos =

VAR productos_total =

COUNTAX('blabla','blabla'[Cant_CA]) +

COUNTAX('blabla','blabla'[Cant_CC]) +

COUNTAX('blabla','blabla'[Cant_TC]) +

COUNTAX('blabla','blabla'[Cant_CD])

return

AVERAGEX('blabla',productos_total)

Thanks in advance,

IC