Average Sales

[Anonymous]

Hi Guy,

I'm trying to calculate current Year Avg sales. when i filter to current Year i get this value with sales for this year instead Avg. see DAX below

[vapid128]

I am a little bit missunderstand, 

your [sales] should be a sum of somthing

Let's say 2021 sales = 200, 2020 sales =100

If you select 2021 2020, [sales] = 300, [avg sales] = 150

if you select 2021, [sales] = 200,  [avg sales] =200

everytime when you select one year, it is the sales value.

[Anonymous]

@vapid128  Everything i select 2022, it give me the same as Total year instead of avg

[v-rzhou-msft · Accepted solution]

Hi @Anonymous ,

I agree with vapid128 's reply. I think your average is calcualted based on years and sales measure. I think sales measure should be created by SUM() function.

My Sample:

Measure:

Sales_ = SUM('Table'[Sales])

Avg Sales = 
CALCULATE(AVERAGEX(VALUES('Calendar'[Fiscal Year]),[Sales_]))

Result:

You see when I select 2022, I could only get average the same as the total in 2022. If you sum to calculate the sales, Power BI will take the same year as a whole.

What kind of result do you want? If you want to get 100 as average in 2022, please do not use sales measure. 

Try this code.

Avg Sales = 
AVERAGEX('Table','Table'[Sales])

Result is as below.

Best Regards,
Rico Zhou

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

[vapid128]

averagex(values([year]),calculate([sales]))

[Anonymous]

@vapid128 
The same thing result