Averages - Calculated Column vs Measure - And Table relationship

Question

Lets take the following tables&nbsp;Table 1 - InvoicesDate,&nbsp; Supplier, Invoice Nbr, Item Code, Qty, Price, Line&nbsp;Value01/02&nbsp; &nbsp; S1&nbsp; &nbsp; &nbsp;1234&nbsp; &nbsp; ABC&nbsp; &nbsp; 5&nbsp; &nbsp; 20.00&nbsp; &nbsp; 100.0001/02&nbsp; &nbsp; S2&nbsp; &nbsp; &nbsp;1235&nbsp; &nbsp; ABC&nbsp; &nbsp; 5&nbsp; &nbsp; 21.00&nbsp; &nbsp; 105.0001/02&nbsp; &nbsp; S1&nbsp; &nbsp; &nbsp;1236&nbsp; &nbsp; XYZ&nbsp; &nbsp; 5&nbsp; &nbsp; 20.00&nbsp; &nbsp; 100.0001/02&nbsp; &nbsp; S1&nbsp; &nbsp; &nbsp;1237&nbsp; &nbsp; XYZ&nbsp; &nbsp; 5&nbsp; &nbsp; 20.00&nbsp; &nbsp; 100.0001/02&nbsp; &nbsp; S1&nbsp; &nbsp; &nbsp;1238&nbsp; &nbsp; ABC&nbsp; &nbsp; 5&nbsp; &nbsp; 19.00&nbsp; &nbsp; 95.0001/02&nbsp; &nbsp; S1&nbsp; &nbsp; &nbsp;1239&nbsp; &nbsp; ABC&nbsp; &nbsp; 5&nbsp; &nbsp; 18.00&nbsp; &nbsp; 90.00&nbsp;Table 2 - SuppliersTable 3 - Items&nbsp;The ultimate goal is to count how many times the supplier offered a price above the total average or the Item.So in the above instance...- Item ABC has an average Buy Price of 88/4 =22&nbsp;So I want to count how many times the buy price for each supplier was above (or below) that average.I thought to do it I would need a flag on each row in the table that determined whether that buy price was above or below the average.&nbsp;Could someone please assist as I am going around in circles on this.I have measures that calculate the Total Average for the Item, and another for specific suppliers.&nbsp;&nbsp;What I am battling with is flagging each row in a way that tells me whether it as greater or less than the average buy price.&nbsp;Do I assume I need a Measure or Calculated column on the Stock table for Averge Buy price.And then a calculated column in the Invoices table that compares the price field to the Stock measure ?&nbsp;Any thoughts greatly appreciated.&nbsp;

liviolanzo · Accepted Answer

Hi&nbsp;shaunwilks&nbsp;check the file:&nbsp;https://1drv.ms/u/s!AiiWkkwHZChHj0_9NlI0Luaj1J2D&nbsp;&nbsp;

Forum Discussion

Related content

Relationship

Calculating Weighted Average

DAX Measure for Ranking the valid rows and calculating the average rating

Calculating average 12 month average

Average Calculation