Here add new column using this DAX formula, 'avg qty = CALCULATE(AVERAGE(Book1[qty sold]),ALLEXCEPT(Book1,Book1[item number]))' for reference, check this picture,