Help with AVERAGEX

[sw123]

Hi,

I am trying to calculate acerage kg per day in Power BI, but can't get it to work. This is the formula I am trying:

Average / day = AVERAGEX(VALUES(Dates[Date]), [KG])

Where Date comes from my Date table and KG from my Production table. 

The error I get is: Column 'KG' cannot be found or may not be used in this expression.

Can someone help me calculate average kg / day?

[Bibiano_Geraldo]

Hi @sw123 ,

Make sure that this measure exists [KG], if not, create  a new one by this DAX:

Total KG = SUM(Production[KG])

And update your Averagex measure to this:

Average KG per Day = 
AVERAGEX(
    VALUES(Dates[Date]), 
    [Total KG]
)

[johnt75 · Accepted solution]

Try

Average / day =
AVERAGEX ( VALUES ( Dates[Date] ), CALCULATE ( SUM ( Production[KG] ) ) )

[sw123]

Thank you, this did the trick.