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.

v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
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.