SUM and AVERAGE values showing up incorrectly in a visual

[mattyhatton]

I have a table pulling through Actual Lead Times, which is a Calculated column, using the DATEDIFF formula for Order Date and Ship Date. The data within this column is correct, but only correct when it is set to 'Don't Summarise'

The oringal data can be see here for a snippet of one warehouse for January:

WAREHOUSE_MASTER(Warehouse Code)	SHIPMENTS_COMBINED(Order Date)	SHIPMENTS_COMBINED(Planned Ship Date)	SHIPMENTS_COMBINED(Ship Date)	SHIPMENTS_COMBINED(Actual Lead Time)
FGIR01	31/01/2023	01/02/2023	06/06/2023	126
FGIR01	31/01/2023	01/02/2023	06/06/2023	126
FGIR01	31/01/2023	01/02/2023	06/06/2023	126
FGIR01	12/01/2023	12/01/2023	08/02/2023	27
FGIR01	17/01/2023	17/01/2023	08/02/2023	22
FGIR01	17/01/2023	17/01/2023	08/02/2023	22
FGIR01	17/01/2023	17/01/2023	08/02/2023	22
FGIR01	17/01/2023	17/01/2023	08/02/2023	22
FGIR01	17/01/2023	17/01/2023	08/02/2023	22
FGIR01	17/01/2023	17/01/2023	08/02/2023	22
FGIR01	25/01/2023	25/01/2023	08/02/2023	14
FGIR01	25/01/2023	25/01/2023	08/02/2023	14
FGIR01	27/01/2023	27/01/2023	08/02/2023	12
FGIR01	27/01/2023	27/01/2023	08/02/2023	12
FGIR01	17/01/2023	17/01/2023	24/01/2023	7
FGIR01	17/01/2023	01/02/2023	24/01/2023	7
FGIR01	17/01/2023	01/02/2023	24/01/2023	7
FGIR01	17/01/2023	01/02/2023	24/01/2023	7
FGIR01	17/01/2023	01/02/2023	24/01/2023	7
FGIR01	17/01/2023	01/02/2023	24/01/2023	7
FGIR01	17/01/2023	01/02/2023	24/01/2023	7
FGIR01	17/01/2023	01/02/2023	24/01/2023	7
FGIR01	17/01/2023	01/02/2023	24/01/2023	7
FGIR01	17/01/2023	01/02/2023	24/01/2023	7
FGIR01	17/01/2023	01/02/2023	24/01/2023	7
FGIR01	17/01/2023	01/02/2023	24/01/2023	7
FGIR01	17/01/2023	01/02/2023	24/01/2023	7
FGIR01	27/01/2023	27/01/2023	03/02/2023	7
FGIR01	27/01/2023	27/01/2023	03/02/2023	7
FGIR01	20/01/2023	20/01/2023	25/01/2023	5
FGIR01	20/01/2023	20/01/2023	24/01/2023	4
FGIR01	20/01/2023	20/01/2023	24/01/2023	4
FGIR01	20/01/2023	20/01/2023	23/01/2023	3
FGIR01	20/01/2023	20/01/2023	23/01/2023	3
FGIR01	20/01/2023	20/01/2023	23/01/2023	3
FGIR01	20/01/2023	20/01/2023	23/01/2023	3
FGIR01	17/01/2023	17/01/2023	17/01/2023	0
FGIR01	17/01/2023	17/01/2023	17/01/2023	0
FGIR01	17/01/2023	17/01/2023	17/01/2023	0
FGIR01	17/01/2023	17/01/2023	17/01/2023	0
FGIR01	24/01/2023	24/01/2023	24/01/2023	0
FGIR01	24/01/2023	24/01/2023	24/01/2023	0
FGIR01	24/01/2023	24/01/2023	24/01/2023	0
FGIR01	24/01/2023	24/01/2023	24/01/2023	0
FGIR01	24/01/2023	24/01/2023	24/01/2023	0
FGIR01	27/01/2023	27/01/2023	27/01/2023	0
FGIR01	27/01/2023	27/01/2023	27/01/2023	0

The total figure for the actual lead time is 719, with an average of 15.3

I have then created a visual showing the Order Date, by Month and the Warehouse the order is coming from and the Actual Lead Time.

The issue is that the Actual Lead Time values are incorrect, there is no correlation between how much each value is out, there is no correlation between warehouse, or month or anything, they are just wildly inaccurate, ranging from 2-15% 

The results for the SUM of are shown below:

Warehouse	Year	Month	Sum of Actual Lead Time	m_Total 1
FGIR01	2023	January	833	833

I have tried a variety of solutions including Greg's Measure Totals, The Final Word - Microsoft Fabric Community and nothing has worked, please can anyone offer any guidance on this?

Thanks in advance

[lbendlin]

I have then created a visual showing the Order Date, by Month and the Warehouse

How?  Does your data model have a Dates table?  

Your sample data only has one warehouse, so is likely not covering your scenario.