Forum Discussion

stefanot's avatar
stefanot
Frequent Visitor
3 years ago
Solved

Averageif based con current line

Hallo, I've found similar questions to mine in the forum, but it looks like none of them is really what I'm looking for   In PowerPivot/DAX I want to create a measure that represents an averageif o...
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi stefanot ,

     

    Please try:

    AverageNumberofSALES = CALCULATE(AVERAGE('Table'[SALES]),ALLEXCEPT('Table','Table'[Product]))

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

daXtreme's avatar
daXtreme
Icon for Solution Sage rankSolution Sage
3 years ago

You didn't say what you really want, a measure or a calculated column...