Work out average from a new measure

[AdamD123]

Hello,

I kindly had some help me to create a new measure to show the number of days between an order date and receipt date (posting date). Now I have this measure showing the days in between, I would like to understand how I work out the average of these dates.

For example, in the below image I have selected item FA0002 and we have two orders showing a lead time of 13 and 6. The card to the right ideally would show the average of these dates, 9.5:

The measure for the lead time is:

How would I now work out the average - do I need to do another measure for this?

Kind regards,

Adam

[ryan_mayu]

@AdamD123 

you can try this

avg = sumx(values('Table (2)'[Dcoument_No]),[leadtime])/DISTINCTCOUNT('Table (2)'[Dcoument_No])

[AdamD123]

Hi Ryan,

Thank you for your reply. I have tried this but seem to be getting a different result:

[ryan_mayu]

could you pls provide the pbix file?

[AdamD123]

Hello, sorry I am not sure how I do this and there is sensitive data which I would not be allowed to share.

[ryan_mayu]

then you can see what's the difference between my sample data and yours. maybe you can update your sample data.