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.

3 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Community 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.

  • amitchandak's avatar
    amitchandak
    Super 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.

  • 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)