Maybe someone here can help me with my dilemma… I can’t seem to figure out how I can get the AverageListPrice for each row using the Qty and ListPriceExtended columns. I did the measure below for the AverageListPrice, but the SUM statements are taking the sum of the full table and not just the sum of the SKU:
AverageListPrice = SUM(MarkDownRaw[ListPriceExtended]) / SUM(MarkDownRaw[Qty])
Here is the table that I’m working on:
I also included a sample table with breakdown of a SKU:
Thanks in advance!