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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Can you explain what you are trying to do

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.