Solved: AverageIf Syntax for Power BI

PradeepVarma · ‎11-01-2020

Can you suggest syntax in DAX for below Excel formula

Fowmy · ‎11-01-2020

@PradeepVarma

You can a calculated column to your table as follows: Replace Table with your table name

MTBF = 
CALCULATE(
    AVERAGE(Table[Day Between Next Brk]),
    ALLEXCEPT(Table,Table[System Name])
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

Did I answer your question? Mark my post as a solution! and hit thumbs up

Fowmy · ‎11-01-2020

@PradeepVarma

You can a calculated column to your table as follows: Replace Table with your table name

MTBF = 
CALCULATE(
    AVERAGE(Table[Day Between Next Brk]),
    ALLEXCEPT(Table,Table[System Name])
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

Did I answer your question? Mark my post as a solution! and hit thumbs up

AverageIf Syntax for Power BI