average and allexcept formula

[Anonymous]

hi

i am very much new t power bi and i was not able to figure out how the calculation in dax is being performed .can you please help here ?

average = AVERAGE(allexpect[Column2])

allexcpect = CALCULATE(AVERAGE(allexpect[Column2]),ALLEXCEPT(allexpect,allexpect[Column1]))

avergae = CALCULATE(AVERAGE(allexpect[Column2]),ALL(allexpect[Column1]))

[v-danhe-msft]

Hi @Anonymous,

what is your desired result? Do you want to average column2 by Column 1 or Column3 and what data you want to use allexcept?

Could you please offer me more information or post your desired result if possible?

Regards,

Daniel He