Measure created is not totalling correctly

[srrajesh1]

Eligible Deliveries =

SUMX(

    FILTER(

        'Dashboard-23-24',

        ('Dashboard-23-24'[Supplier] = "Zainway Fixed" || 'Dashboard-23-24'[Supplier] = "Own") &&

        'Dashboard-23-24'[Delivered] + 'Dashboard-23-24'[Picked UP] > 'Dashboard-23-24'[Target1]

    ),

    'Dashboard-23-24'[Delivered] + 'Dashboard-23-24'[Picked UP] - 'Dashboard-23-24'[Target1]

)

above is the measure I have created. While calculating total it returns wrong result.

Result is given below.

Correct Total of ELigible deliveries should be 361, where as it simply minus target and gives wrong totalling. Kindly help me to correct it.

Runsheet Date	Supplier	AWB Distinct Count	Delivered	Picked UP	Inside Doha	Out of Doha	Delivered+Picked Up	Target	Eligible Deliveries	Del Amt/Incentive
9/22/2023 0:00	OWN	84	67	13	80		80	30	50	200
9/22/2023 0:00	OWN	50	40	8	41	7	48	30	18	72
9/22/2023 0:00	OWN	57	54	1	55		55	30	25	100
9/22/2023 0:00	OWN	33	27	4	31		31	30	1	4
9/22/2023 0:00	OWN	55	50	0	50		50	30	20	80
9/22/2023 0:00	OWN	63	56	4	59	1	60	30	30	120
9/22/2023 0:00	OWN	71	61	6	67		67	30	37	148
9/22/2023 0:00	OWN	66	55	9		64	64	30	34	136
9/22/2023 0:00	OWN	48	42	4	46		46	30	16	64
9/22/2023 0:00	OWN	56	46	8	54		54	30	24	96
9/22/2023 0:00	OWN	57	51	4	55		55	30	25	100
9/22/2023 0:00	OWN	30	28	0	28		28	30	0	0
9/22/2023 0:00	OWN	67	52	8	60		60	30	30	120
9/22/2023 0:00	OWN	27	22	1	23		23	30	0	0
9/22/2023 0:00	OWN	42	40	2	42		42	30	12	48
9/22/2023 0:00	OWN	70	66	3	69		69	30	39	156
Total		876	757	75	760	72	832	30	802	3208

[tamerj1]

Hi @srrajesh1 

Please try

Eligible Deliveries =
SUMX (
SUMMARIZE (
'Dashboard-23-24',
'Dashboard-23-24'[Runsheet Date],
'Dashboard-23-24'[Supplier]
),
SUMX (
FILTER (
CALCULATETABLE ( 'Dashboard-23-24' ),
( 'Dashboard-23-24'[Supplier] = "Zainway Fixed"
|| 'Dashboard-23-24'[Supplier] = "Own" )
&& 'Dashboard-23-24'[Delivered] + 'Dashboard-23-24'[Picked UP] > 'Dashboard-23-24'[Target1]
),
'Dashboard-23-24'[Delivered] + 'Dashboard-23-24'[Picked UP] - 'Dashboard-23-24'[Target1]
)
)