Average count

Hello

I have connected the BI to my SQL database in which we have for each order, a row in the table with all its information. What I want to see graphically is the average orders per half-hour tranche.

The half-hour sections I have already managed to do with a DAX formula that I found in this same forum. The problem I have now is that when I display the data graphically, I drag the order number (CodOrder) that is unique in each order and with this it makes me count.

The information graphically is correct, since you can see the hours where there are more orders (count). Numerically, it's not what I want to see. I would like to see the average daily orders, as it does not help me to know that in the last year I have had 1521 orders at 17:00, but there have been 8.5 orders on average.

To do this, it would be necessary to average between the days that have elapsed with the filter that has been applied with the data segmentation at the top. What complicates it is that I do not want the average with the days elapsed, but the days that there have been orders.

What maner can I achieve it?

Thank you very much in advance,

Greetings.

DatosDataGráficoGraph