Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

AVERAGEIFS in dax

Hi guys, I would like to know how to transcribe this formula in dax please. Moyenne.si.ens = AVERAGEIFS thank you 🙂    
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

    >>When averaging by multiple conditions,

    You can try this measure,

    Measure = AVERAGEX(FILTER('Table','Table'[Total]<>0 && 'Table'[Parti]="Non" && 'Table'[Equipe]="DevCo"),[%Total])

    Or if you want to create a column, try this 

     

    Best Regards,

    Community Support Team _Tang

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for your answer,
I would like to calculate the average AVERAGEIFS in dax.
- Average_range = N:N (%total)
- Criteria_range1 = M:M (total)
- criteria1 = "<>0"
- Criteria_range2 = F:F (months)