Average Sales per Salesperson with Conditions

[OracleGuru]

I'm trying to calculate the average sales per salesperson for each month while excluding sales reps that have sales below a certain dollar amount.  In the example below, if the total sales for the month for each salesperson was less than $100, I want to exclude that salesperson from the "Average Sales per Salesperson" calculation.  In the table below, salesperson A had January sales of $1,000, salesperson B, $99 and salesperson C, $500.  Since salesperson B's sales were under $100, I want to exclude him from the calculation.  The result of the calculation should be $750.  Salesperson A and C had sales over $100 and their total sales were $1,500.

[parry2k · Accepted solution]

@OracleGuru Try following measure, I'm assuing you have calendar table in your model and it has month table like Jan, 2019, Feb, 2019

Avg for sales above 100 = 
AVERAGEX(  
    SUMMARIZE( 
        Salesperson, 
        'Calendar'[Month Year], 
        Salesperson[Sales Person] 
    ),
    IF( [Sum] >= 100, [Sum] ) 
)

Sum is just sum of sales, replace column and table name as per your model. 

[OracleGuru]

Thank You