Count Average days between date difference

[10664334]

Hi all

I have made this measure called AVG delivery days ( see second last image for formula), however once I try to put it on a visual there is data missing, we have more deliveries for other departments in February, for example DEP 615, but I have nothing. Not all orders have a delivery date, (is this impacting my results as its a null value)

I have tried doing a column on the query editor for the difference but the null values still come as 0 and I cannot get a result.

Please let me know a solution No data for departments with empty datesMeasure AVG DELIVERY DAYSDate values ETA and Delivery Start

[Ahmedx]

I'm not sure if I understood you correctly, but try writing like this:

AVE RAG EX (
SUMMARIZE(ALLSELECTED('Ops Master'),'Ops Master’[ETA],'Ops Master’[DELIVERY START]),
DATEDIFF(’Ops Master’[ETA],’Ops Master’[DELIVERY START],DAY))

[10664334]

Hi Ahmed 

Can you help me out? 

[10664334]

Hi Amhed,

I just basically want the difference betwen Delivery Start minus the ETA, and then get the average days.

But as I have empty cells I cant get accurate data. Hope this helps 

I have tried copying pasting the above but I only get the same value 

I need to count the rows that have a date value not the blanks, otherwise its not accurate 

[10664334]

Pretty much this average highlighted