Daily AVG Sum

[netanel]

Hello everyone!
I have a formula for calculating a daily average

Net USD average per Day =

AVERAGEX(

    KEEPFILTERS(VALUES('Date'[Date].[Day])),

    CALCULATE(SUM('Revenues DB'[Net USD]))

)

I try to do the same formula but without SUM because as soon as I rise to the level of the quarter or year the amounts is wrong

[VahidDM]

Hi @netanel 

Try this:

Net USD average per Day =
VAR _A =
    SUMMARIZE( 'Date', 'Date'[Date], "NetUSD", SUM( 'Revenues DB'[Net USD] ) )
RETURN
    AVERAGEX( _A, [NetUSD] )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[amitchandak · Accepted solution]

@netanel , Prefer to have date without timestamp and try a measure like

Net USD average per Day =
AVERAGEX(
VALUES('Date'[Date]),
CALCULATE(SUM('Revenues DB'[Net USD]))
)