Getting the minimum summed category

[zyeet]

I have been trying to get the category name by summing all the values of products in each category. So far, this has worked right for getting the maximum summed category but not minimum. The measures I have used so far are:

SumMax = SUMX('FB Truck Data',Max('FB Truck Data'[Daily Dispensed])) 

for getting the maximum sum in each category

SumMin = SUMX('FB Truck Data',Min('FB Truck Data'[Daily Dispensed]))

for getting the minimum sum in each category

Maximum Dispensed Quantity Customer =

CALCULATE (

    MIN ( 'FB Truck Data'[Customer Name] ),

    FILTER ( 'FB Truck Data', MAXX ( 'FB Truck Data', [Daily Dispensed] ) = [SumMax] )

)

to get the customer name with max sum

Minimum Dispensed Quantity Customer =

CALCULATE (

    MIN ( 'FB Truck Data'[Customer Name] ),

    FILTER ( 'FB Truck Data', MINX ( 'FB Truck Data', [Daily Dispensed] ) = [SumMin] )

)

to get the customer name with min sum. This is where the issue is. It is not giving me the right minimum summed category.

As we can see in the table below, the values are already summed and showing up individually for each customer, and my maximum returns the right customer (Byrne Equipments), but Minimum returns the wrong customer (Clear Ice), instead of 'Sarab Al Madina'. I don't really understand why because sum min value gives 46.29 and not 130.70.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...