topic Re: Average Sales in DAX Commands and Tips

Average Sales

Anonymous — Fri, 10 Jun 2022 00:01:29 GMT

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

Re: Average Sales

vapid128 — Fri, 10 Jun 2022 00:12:20 GMT

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

Re: Average Sales

Anonymous — Fri, 10 Jun 2022 00:35:36 GMT

vapid128
The same thing result

Re: Average Sales

vapid128 — Fri, 10 Jun 2022 00:52:03 GMT

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.

Re: Average Sales

Anonymous — Fri, 10 Jun 2022 00:58:54 GMT

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

Re: Average Sales

Anonymous — Wed, 15 Jun 2022 06:40:07 GMT

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.