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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi stefanot ,

 

You can achieve this by changing the aggregation of SALES directly:

Output:

 

Besides, this question is beyond the topic discussed at the beginning of the thread. So to be able to better help other users, if you still have any other questions, please consider marking the replies that are useful to you and creating a thread about the new topic, which will allow the thread to be addressed more efficiently.

Thanks in advance!

 

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.