Differenr results then expected

[shaykoooo]

Hi,

In sheet "???", I have two measres, Average Quantity Sold per Day = AVERAGEX(VALUES(Dates[Date]),[Total Quantity Sold]) and Average Quantity Sold per Day 2 = AVERAGEX(VALUES(Dates[Date]),SUM(Sales[Quantity])) not returning the same result as I expect. What is the reason for that?

The measue [Total Quantity Sold] is bulit from the expression SUM(Sales[Quantity]) and that's why I assumed it would return the same results...

TY

[Zubair_Muhammad · Accepted solution]

@shaykoooo

You should wrap the sum inside calculate to transform the ROW context into FILTER CONTEXT

Average Quantity Sold per Day 2 =
AVERAGEX ( VALUES ( Dates[Date] ), CALCULATE ( SUM ( Sales[Quantity] ) ) )

[shaykoooo]

And in the first measure there is no need to wrap the measure [Total Quantity Sold] there is no need to with CALCULATE since measures have an Implicit CALCULATE?