Forum Discussion
Solved
SumX Incorrect totals between different years.
Trying to Sumx measure "ptl cost" , "2025 Cost", "Savings". I need to be able to sum the total of selections in the table. Due to work security, i can not upload a copy of the file. I will post ...
Hi GVallentgoed ,
Try using the following formula:
sumx ptl cost = CALCULATE(SUMX(VALUES('Data'[Destination Name]),Data[Ptl Cost]),ALLSELECTED(Data))Sumx Savings = CALCULATE(SUMX(VALUES('Data'[Destination Name]),'Data'[Savings]),ALLSELECTED('Data'))sumx 2025 = CALCULATE(SUMX(VALUES('Data'[Destination Name]),Data[2025 Cost]),ALLSELECTED(data))Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
| Rate Year | Trip Cost | Latest Delivery | Destination Name | LBS | 2024 LBS | 2025 LBS | 2024 Rates | 2025 Rates |
| 2024 | $ 589.07 | 2024-01-03 09:00 | COSTCO DEPOT 572 | 17,012.63 | 17,012.63 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-01-05 09:00 | COSTCO DEPOT 572 | 10,326.75 | 10,326.75 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-01-10 09:00 | COSTCO DEPOT 572 | 13,589.50 | 13,589.50 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-01-12 05:00 | COSTCO DEPOT 571 | 31,970.00 | 31,970.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-01-12 05:30 | COSTCO DEPOT 571 | 33,693.56 | 33,693.56 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-01-12 09:00 | COSTCO DEPOT 572 | 12,697.50 | 12,697.50 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-01-12 09:30 | COSTCO DEPOT 1034 DRY | 16,894.34 | 16,894.34 | $ 4,973.89 | ||
| 2024 | $ 5,825.17 | 2024-01-13 08:15 | COSTCO DEPOT 76 | 10,158.00 | 10,158.00 | $ 5,825.17 | ||
| 2024 | $ 1,091.89 | 2024-01-15 09:15 | COSTCO DEPOT 574 WET | 12,697.50 | 12,697.50 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-01-15 09:45 | COSTCO DEPOT 574 WET | 21,849.50 | 21,849.50 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-01-16 10:00 | COSTCO DEPOT 572 | 12,697.50 | 12,697.50 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-01-18 09:15 | COSTCO DEPOT 574 WET | 16,930.00 | 16,930.00 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-01-18 10:00 | COSTCO DEPOT 572 | 16,930.00 | 16,930.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-01-19 06:00 | COSTCO DEPOT 571 | 41,961.42 | 41,961.42 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-01-20 06:00 | COSTCO DEPOT 1034 DRY | 15,612.90 | 15,612.90 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-01-22 08:45 | COSTCO DEPOT 574 WET | 16,808.00 | 16,808.00 | $ 1,091.89 | ||
| 2024 | $ 5,825.17 | 2024-01-23 05:45 | COSTCO DEPOT 76 | 30,745.69 | 30,745.69 | $ 5,825.17 | ||
| 2024 | $ 1,091.89 | 2024-01-25 09:15 | COSTCO DEPOT 574 WET | 33,822.25 | 33,822.25 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-01-25 09:30 | COSTCO DEPOT 1034 DRY | 40,714.50 | 40,714.50 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-01-25 09:30 | COSTCO DEPOT 572 | 33,822.25 | 33,822.25 | $ 589.07 | ||
| 2024 | $ 5,825.17 | 2024-01-25 11:34 | COSTCO DEPOT 76 | 13,778.75 | 13,778.75 | $ 5,825.17 | ||
| 2024 | $ 4,973.89 | 2024-01-29 05:00 | COSTCO DEPOT 1034 DRY | 25,282.88 | 25,282.88 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-01-29 05:00 | COSTCO DEPOT 571 | 30,555.00 | 30,555.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-01-30 08:00 | COSTCO DEPOT 572 | 30,872.75 | 30,872.75 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-01-30 08:45 | COSTCO DEPOT 574 WET | 27,486.75 | 27,486.75 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-02-01 05:00 | COSTCO DEPOT 1034 DRY | 25,070.88 | 25,070.88 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-02-01 08:45 | COSTCO DEPOT 574 WET | 23,527.06 | 23,527.06 | $ 1,091.89 | ||
| 2024 | $ 5,825.17 | 2024-02-01 09:00 | COSTCO DEPOT 76 | 20,319.25 | 20,319.25 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-02-01 11:00 | COSTCO DEPOT 572 | 23,111.06 | 23,111.06 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-02-02 05:00 | COSTCO DEPOT 571 | 30,555.00 | 30,555.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-02-02 07:30 | COSTCO DEPOT 571 | 21,326.00 | 21,326.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-02-02 11:00 | COSTCO DEPOT 572 | 16,731.31 | 16,731.31 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-02-05 05:00 | COSTCO DEPOT 1034 DRY | 20,590.38 | 20,590.38 | $ 4,973.89 | ||
| 2024 | $ 5,825.17 | 2024-02-05 12:42 | COSTCO DEPOT 76 | 28,415.63 | 28,415.63 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-02-06 06:30 | COSTCO DEPOT 572 | 33,406.25 | 33,406.25 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-02-06 09:15 | COSTCO DEPOT 574 WET | 33,822.25 | 33,822.25 | $ 1,091.89 | ||
| 2024 | $ 5,825.17 | 2024-02-08 07:36 | COSTCO DEPOT 76 | 21,820.50 | 21,820.50 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-02-08 08:00 | COSTCO DEPOT 572 | 29,260.38 | 29,260.38 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-02-08 08:45 | COSTCO DEPOT 574 WET | 23,527.06 | 23,527.06 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-02-08 10:00 | COSTCO DEPOT 572 | 10,816.00 | 10,816.00 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-02-08 11:00 | COSTCO DEPOT 1035 WET | 24,290.00 | 24,290.00 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-02-09 06:00 | COSTCO DEPOT 1034 DRY | 44,593.75 | 44,593.75 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-02-10 05:30 | COSTCO DEPOT 571 | 30,555.00 | 30,555.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-02-13 06:30 | COSTCO DEPOT 572 | 24,576.56 | 24,576.56 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-02-13 06:30 | COSTCO DEPOT 571 | 23,086.89 | 23,086.89 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-02-13 11:05 | COSTCO DEPOT 1035 WET | 20,820.00 | 20,820.00 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-02-15 05:00 | COSTCO DEPOT 1034 DRY | 16,800.15 | 16,800.15 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-02-15 09:15 | COSTCO DEPOT 574 WET | 25,284.94 | 25,284.94 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-02-16 11:35 | COSTCO DEPOT 1035 WET | 20,820.00 | 20,820.00 | $ 4,973.89 |
| 2024 | $ 4,973.89 | 2024-02-20 07:30 | COSTCO DEPOT 1034 DRY | 24,341.14 | 24,341.14 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-02-20 09:30 | COSTCO DEPOT 572 | 17,676.25 | 17,676.25 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-02-21 10:35 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-02-22 09:15 | COSTCO DEPOT 574 WET | 24,025.00 | 24,025.00 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-02-22 10:00 | COSTCO DEPOT 572 | 21,908.75 | 21,908.75 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-02-23 08:00 | COSTCO DEPOT 571 | 36,726.34 | 36,726.34 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-02-26 05:00 | COSTCO DEPOT 571 | 31,918.00 | 31,918.00 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-02-26 05:19 | COSTCO DEPOT 1034 DRY | 39,187.70 | 39,187.70 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-02-27 09:15 | COSTCO DEPOT 574 WET | 27,372.19 | 27,372.19 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-02-27 11:00 | COSTCO DEPOT 572 | 26,580.25 | 26,580.25 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-02-28 05:30 | COSTCO DEPOT 571 | 27,848.77 | 27,848.77 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-03-03 21:14 | COSTCO DEPOT 1035 WET | 24,290.00 | 24,290.00 | $ 4,973.89 | ||
| 2024 | $ 5,825.17 | 2024-03-04 06:00 | COSTCO DEPOT 76 | 33,583.06 | 33,583.06 | $ 5,825.17 | ||
| 2024 | $ 4,973.89 | 2024-03-04 11:00 | COSTCO DEPOT 1034 DRY | 35,962.33 | 35,962.33 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-03-04 12:05 | COSTCO DEPOT 1035 WET | 24,290.00 | 24,290.00 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-03-05 06:30 | COSTCO DEPOT 571 | 33,047.53 | 33,047.53 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-03-05 07:00 | COSTCO DEPOT 1034 DRY | 41,568.44 | 41,568.44 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-03-05 07:30 | COSTCO DEPOT 571 | 31,401.38 | 31,401.38 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-03-05 09:15 | COSTCO DEPOT 574 WET | 21,927.94 | 21,927.94 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-03-05 10:00 | COSTCO DEPOT 572 | 29,601.00 | 29,601.00 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-03-07 07:00 | COSTCO DEPOT 1034 DRY | 19,782.45 | 19,782.45 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-03-07 08:00 | COSTCO DEPOT 1034 DRY | 31,677.81 | 31,677.81 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-03-07 11:00 | COSTCO DEPOT 572 | 11,851.00 | 11,851.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-03-08 05:00 | COSTCO DEPOT 571 | 42,449.40 | 42,449.40 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-03-08 10:00 | COSTCO DEPOT 572 | 18,227.81 | 18,227.81 | $ 589.07 | ||
| 2024 | $ 5,825.17 | 2024-03-09 09:15 | COSTCO DEPOT 76 | 41,554.06 | 41,554.06 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-03-11 07:30 | COSTCO DEPOT 571 | 30,555.00 | 30,555.00 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-03-11 10:00 | COSTCO DEPOT 1034 DRY | 34,920.00 | 34,920.00 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-03-11 10:35 | COSTCO DEPOT 1035 WET | 24,290.00 | 24,290.00 | $ 4,973.89 | ||
| 2024 | $ 5,825.17 | 2024-03-11 12:00 | COSTCO DEPOT 76 | 27,624.63 | 27,624.63 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-03-12 06:00 | COSTCO DEPOT 572 | 22,174.25 | 22,174.25 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-03-12 08:15 | COSTCO DEPOT 574 WET | 34,025.25 | 34,025.25 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-03-12 10:00 | COSTCO DEPOT 571 | 31,748.89 | 31,748.89 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-03-12 11:00 | COSTCO DEPOT 572 | 12,697.50 | 12,697.50 | $ 589.07 | ||
| 2024 | $ 5,825.17 | 2024-03-13 06:00 | COSTCO DEPOT 76 | 22,536.69 | 22,536.69 | $ 5,825.17 | ||
| 2024 | $ 5,825.17 | 2024-03-13 06:00 | COSTCO DEPOT 76 | 25,098.75 | 25,098.75 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-03-14 05:30 | COSTCO DEPOT 571 | 36,152.59 | 36,152.59 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-03-14 06:00 | COSTCO DEPOT 572 | 22,719.88 | 22,719.88 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-03-14 08:15 | COSTCO DEPOT 574 WET | 20,071.25 | 20,071.25 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-03-14 08:30 | COSTCO DEPOT 571 | 45,110.00 | 45,110.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-03-15 05:00 | COSTCO DEPOT 571 | 45,110.00 | 45,110.00 | $ 589.07 | ||
| 2024 | $ 5,825.17 | 2024-03-15 08:00 | COSTCO DEPOT 76 | 29,463.75 | 29,463.75 | $ 5,825.17 | ||
| 2024 | $ 4,973.89 | 2024-03-15 08:30 | COSTCO DEPOT 1034 DRY | 40,376.25 | 40,376.25 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-03-15 08:30 | COSTCO DEPOT 572 | 12,697.50 | 12,697.50 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-03-16 07:00 | COSTCO DEPOT 1034 DRY | 20,081.83 | 20,081.83 | $ 4,973.89 | ||
| 2024 | $ 5,825.17 | 2024-03-16 09:15 | COSTCO DEPOT 76 | 22,548.19 | 22,548.19 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-03-18 05:00 | COSTCO DEPOT 571 | 31,646.25 | 31,646.25 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-03-18 06:05 | COSTCO DEPOT 1035 WET | 31,230.00 | 31,230.00 | $ 4,973.89 | ||
| 2024 | $ 5,825.17 | 2024-03-18 06:45 | COSTCO DEPOT 557 WET | 20,820.00 | 20,820.00 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-03-18 09:00 | COSTCO DEPOT 571 | 42,024.75 | 42,024.75 | $ 589.07 |