Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

average and allexcept formula

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]))

Need Help

1 Reply

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    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