Average Measures (Monthly & Yearly) are not working properly

[Anonymous]

Hello! So I am creating two measures that will calculate the average monthly & yearly from total cost for fiscal month/year. It seems to be just cacluating the total cost and duplicating the values for each month but if you look at the sum totals they are different. Could it but the [Fiscal Year] or [Fiscal Month Name], can anyone provide some assistance?    

NPD_ST_AVGMonthly = 
AVERAGEX(
    VALUES('Date'[Fiscal Month Name]),
    [NPD_ST_TotalCost]
    )

NPD_ST_AVGYearly = 
AVERAGEX(
    VALUES('Date'[Fiscal Year]),
    [NPD_ST_TotalCost]
    )

NPD_ST_TotalCost = SUM('NP_SP_ST_Combined'[Materials Cost]) + SUM('NP_SP_ST_Combined'[Labor Cost])

[Anonymous · Accepted solution]

Hi @Anonymous 

This will always duplicate because FY2015 will always be 1 value and hence it will be same. So ideally the measure should be same for all months and years because it is average.

1. Averagex(all(fiscal year),total cost.

2. Averagex(all(Month Name),Total Cost.

Please mark solution if this works with you.

[amitchandak]

@Anonymous , not sure what is wrong with monthly

may be you need this

NPD_ST_AVGMonthly=
calculate(AVERAGEX(
VALUES('Date'[Fiscal Month Name]),
[NPD_ST_TotalCost]
), filter(all('Date') , 'Date'[Fiscal Year] =max('Date'[Fiscal Year])))

or this you need for yearly

NPD_ST_AVGYearly =
calculate(AVERAGEX(
VALUES('Date'[Fiscal Month Name]),
[NPD_ST_TotalCost]
), filter(all('Date') , 'Date'[Fiscal Year] =max('Date'[Fiscal Year])))

or you need for yearly

NPD_ST_AVGYearly =
calculate(AVERAGEX(
VALUES('Date'[Fiscal Year]),
[NPD_ST_TotalCost]
),all('Date') )