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