Forum Discussion

shaykoooo's avatar
shaykoooo
Icon for Helper I rankHelper I
8 years ago
Solved

Differenr results then expected

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(Sal...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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] ) ) )
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

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's avatar
shaykoooo
Icon for Helper I rankHelper I
8 years ago
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?