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

[Kamkazz]

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

[v-xiaotang]

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.

[Greg_Deckler]

@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])

[Kamkazz]

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?