Forum Discussion

jorge_mejia's avatar
jorge_mejia
New Member
9 years ago
Solved

Manipulating Measures by Different Cuts

Hello Power BI Community,     I am trying to calculate the Average Sales Price (ASP) for each material in my database. The database is basically thousands of single purchasing transactions: ...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi jorge_mejia,

    Please create a measure using the similar formulas.

    Average=CALCULATE(AVERAGE(Table[Sales Price]),ALLEXCEPT(Table,Table[material]))


    I test using my sample table.



    Create a measure using the formula using the formula below and get expected result.

    Average = CALCULATE(AVERAGE(Table1[value]),ALLEXCEPT(Table1,Table1[Material]))



    Best Regards,
    Amgelia


v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi jorge_mejia,

Please create a measure using the similar formulas.

Average=CALCULATE(AVERAGE(Table[Sales Price]),ALLEXCEPT(Table,Table[material]))


I test using my sample table.



Create a measure using the formula using the formula below and get expected result.

Average = CALCULATE(AVERAGE(Table1[value]),ALLEXCEPT(Table1,Table1[Material]))



Best Regards,
Amgelia