topic How to calculate average week sales of a ID POS with only correlation of ID terminals between tables in DAX Commands and Tips

How to calculate average week sales of a ID POS with only correlation of ID terminals between tables

Kamkazz — Sat, 01 Oct 2022 14:36:29 GMT

Hello comunity,

I have this problem and i cant get the DAX language to create a formula that can give me the weekly average of sales of each point of sales (not terminal).

I have three tables (check image). One i have the sales by week and by terminal, the second i have the terminal number and the POS that terminal referer too and the third table is a calendar by week table.

When I create a table by week and the ID is the point of sale it sums right the amount, but when I create the average formula to go along the table, it gives me the weekly average by terminal.

Can you help with this formula?

Best regards.

Mário

Re: How to calculate average week sales of a ID POS with only correlation of ID terminals between tables

Greg_Deckler — Sat, 01 Oct 2022 14:40:55 GMT

Kamkazz Try putting Point of Sale in a table visual along with Week and then this measure:

POS Weekly Average Measure = VAR __Table = SUMMARIZE('Sales by Terminal',[Terminal],"__Sum",SUM('Sales by Terminal'[Sales])) RETURN AVERAGEX(__Table,[__Sum])

Re: How to calculate average week sales of a ID POS with only correlation of ID terminals between tables

Kamkazz — Sun, 02 Oct 2022 12:26:48 GMT

Hello Greg, dont get this part "Var __Table" and the "__Sum"

 VAR __Table = SUMMARIZE('Sales by Terminal',[Terminal],"__Sum",SUM('Sales by Terminal'[Sales]))
RETURN
  AVERAGEX(__Table,[__Sum])

Can you be more specific?

Re: How to calculate average week sales of a ID POS with only correlation of ID terminals between tables

v-xiaotang — Mon, 03 Oct 2022 11:07:04 GMT

Hi Kamkazz

Thanks for reaching out to us.

could you share some sample data and its expected output? thanks

Best Regards,

Community Support Team _Tang

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