Forum Discussion

netanel's avatar
netanel
Post 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 think it's because the formula also calculates BLANK
How do I ignore BLANK in such a formula like this?
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]
    )

1 Reply

  • amitchandak's avatar
    amitchandak
    Super 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]
    )