Measure to average items in Column C but only when Column B is 2

[JohnBerk]

I'm trying to fgiure out how to create a measuer to Calculate the average billed amount but only for lines with Billing status code 2.  Should be (200+150+350+400)/4 = 375 but nothing I have tried has work.  Unfortuately I'm new to PowerBI

Wip table

[dax · Accepted solution]

Hi JohnBerk,

You could try below measure 

AVG1 =
IF (
    MIN ( bill[code] ) = 2,
    CALCULATE ( AVERAGE ( bill[amount] ), ALLEXCEPT ( bill, bill[code] ) ),
    0
)

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hey @JohnBerk 

Try the below (make sure table & column names match your table & columns)

AVG = 
CALCULATE(
    AVERAGE(Table1[BilledAmt]),
    Table1[StatusCode] = 2
)