average of sum

[rufmau68]

Hi, im new in power bi and i fighting with DAX language

hi have calculated a measure with this

A = iferror(sum(SCHEDA_CNT_AZIENDA_ENTE[A_PERCORRENZA_EFFETTIVA])/sum(SCHEDA_CNT_AZIENDA_ENTE[A_VEICOLI_UTILIZZATI]), blank())

if i list it, by DENOM_ENTE Category , follows the  result: BUT I NEED TO CALCULATE avg(A) , and i dont know hot to calculate it

[v-jayw-msft]

Hi @rufmau68 ,

You want to calculate the average of [A] which is [A]/count of category?

If so you could try the following measure.

[A]/calculate(distinctcount(category),all(table))

If not, please show some sample data and expected result to us.

Best Regards,

Jay

[amitchandak]

@rufmau68 , A seem to Avg Already X/Y

Try Like

Divide(sum(SCHEDA_CNT_AZIENDA_ENTE[A_PERCORRENZA_EFFETTIVA]),sum(SCHEDA_CNT_AZIENDA_ENTE[A_VEICOLI_UTILIZZATI]))

Usually, If we want sum till category and avg after that of a measure A, then we will do 

Averagex(Value(Table[Category]), [Measure])

[rufmau68]

dont works neither if i wont to match every sum() by denom_ente with grand total

with womthinks like this

grandTotal = calculate(sum(SCHEDA_CNT_AZIENDA_ENTE[A_PERCORRENZA_EFFETTIVA]),all(Calendario[Anno]))

[rufmau68]

i try it but dont works: it return the same value in A column, it seems that it dont overrides category table contest... (*)

(*) i use values() and not value(), because value() need measure column name and not category column name

avgA= Averagex(Values(SCHEDA_CNT_AZIENDA_ENTE[ANNO]), divide(sum(SCHEDA_CNT_AZIENDA_ENTE[A_PERCORRENZA_EFFETTIVA]),sum(SCHEDA_CNT_AZIENDA_ENTE[A_VEICOLI_UTILIZZATI])))