AVERAGEIFS in dax

[Anonymous]

Hi guys,

I would like to know how to transcribe this formula in dax please.

Moyenne.si.ens = AVERAGEIFS

thank you 🙂

[v-xiaotang · Accepted solution]

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]

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)

[amitchandak]

@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.