Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
srrajesh1
New Member

Measure created is not totalling correctly

 

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 DateSupplierAWB Distinct CountDeliveredPicked UPInside DohaOut of DohaDelivered+Picked UpTargetEligible DeliveriesDel Amt/Incentive
9/22/2023 0:00OWN84671380 803050200
9/22/2023 0:00OWN5040841748301872
9/22/2023 0:00OWN5754155 553025100
9/22/2023 0:00OWN3327431 313014
9/22/2023 0:00OWN5550050 50302080
9/22/2023 0:00OWN63564591603030120
9/22/2023 0:00OWN7161667 673037148
9/22/2023 0:00OWN66559 64643034136
9/22/2023 0:00OWN4842446 46301664
9/22/2023 0:00OWN5646854 54302496
9/22/2023 0:00OWN5751455 553025100
9/22/2023 0:00OWN3028028 283000
9/22/2023 0:00OWN6752860 603030120
9/22/2023 0:00OWN2722123 233000
9/22/2023 0:00OWN4240242 42301248
9/22/2023 0:00OWN7066369 693039156
Total 8767577576072832308023208
 
1 REPLY 1
tamerj1
Super User
Super User

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]
)
)

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors