Forum Discussion

netanel's avatar
netanel
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

AVG Problem

Hey All!   This is my measure: Net USD average per Day = AVERAGEX(     KEEPFILTERS(VALUES('Date'[Date])),     CALCULATE(SUM('Revenues DB'[Net USD])) )   I can not reach the exact amount I...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    netanel ,

     

    AVERAGEX(
    (VALUES('Date'[Date])),
    CALCULATE(SUM('Revenues DB'[Net USD]))
    )

    or

     

    AVERAGEX(
    summarize('Revenues DB' , 'Date'[Date], "_1",
    CALCULATE(SUM('Revenues DB'[Net USD])) ), [_1]
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

netanel ,

 

AVERAGEX(
(VALUES('Date'[Date])),
CALCULATE(SUM('Revenues DB'[Net USD]))
)

or

 

AVERAGEX(
summarize('Revenues DB' , 'Date'[Date], "_1",
CALCULATE(SUM('Revenues DB'[Net USD])) ), [_1]
)