Avg of hourly sales

[Merororiotuty_y]

Hello all, 

I have a raw data with count figures (number of sales per day per hour) 

I used the sum function to get the total of each date per hour. (I'm also using a slicer to filter certain dates/hours) to compare the peak hours amoung diffrent timing/dates 

However, I'm not sure how to get the average of the sales (when i use the average measure ) it only gives the average of certain timings e.g. most of my sales per hour is 2-3, so the average is 2.5. However the actual average depends on the sum of the total sales. 

below is a sample of my data. 

Date	hour	Sales No
1-1-2023	0	2
1-1-2023	1	1
1-1-2023	2	3
1-1-2023	3	3
1-1-2023	4	2
1-1-2023	5	3
1-1-2023	6	2
2-1-2023	0	3
2-1-2023	1	2

[v-zhangti]

Hi, @Merororiotuty_y 

Based on the sample data you provided, can you tell me what output you expect? You can also show it with pictures or Excel.

Best Regards,

Community Support Team _Charlotte

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