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.
| 2024 | $ 589.07 | 2024-03-19 05:00 | COSTCO DEPOT 571 | 30,541.57 | 30,541.57 | $ 589.07 | |||
| 2024 | $ 589.07 | 2024-03-19 05:00 | COSTCO DEPOT 571 | 37,238.44 | 37,238.44 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-03-19 09:15 | COSTCO DEPOT 574 WET | 30,588.50 | 30,588.50 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-03-19 10:00 | COSTCO DEPOT 572 | 30,588.50 | 30,588.50 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-03-21 07:15 | COSTCO DEPOT 574 WET | 30,588.50 | 30,588.50 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-03-21 10:00 | COSTCO DEPOT 572 | 28,660.25 | 28,660.25 | $ 589.07 | |||
| 2024 | $ 4,973.89 | 2024-03-21 11:00 | COSTCO DEPOT 1034 DRY | 21,402.75 | 21,402.75 | $ 4,973.89 | |||
| 2024 | $ 589.07 | 2024-03-22 05:00 | COSTCO DEPOT 571 | 27,951.92 | 27,951.92 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-03-22 09:45 | COSTCO DEPOT 574 WET | 28,182.44 | 28,182.44 | $ 1,091.89 | |||
| 2024 | $ 1,091.89 | 2024-03-22 09:45 | COSTCO DEPOT 574 WET | 28,182.44 | 28,182.44 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-03-22 10:00 | COSTCO DEPOT 572 | 28,660.25 | 28,660.25 | $ 589.07 | |||
| 2024 | $ 4,973.89 | 2024-03-25 06:05 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | |||
| 2024 | $ 1,091.89 | 2024-03-26 09:15 | COSTCO DEPOT 574 WET | 28,182.44 | 28,182.44 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-03-26 10:00 | COSTCO DEPOT 571 | 45,110.00 | 45,110.00 | $ 589.07 | |||
| 2024 | $ 589.07 | 2024-03-26 11:00 | COSTCO DEPOT 572 | 22,174.25 | 22,174.25 | $ 589.07 | |||
| 2024 | $ 5,825.17 | 2024-04-02 06:15 | COSTCO DEPOT 557 WET | 34,700.00 | 34,700.00 | $ 5,825.17 | |||
| 2024 | $ 5,825.17 | 2024-04-02 09:00 | COSTCO DEPOT 76 | 29,042.69 | 29,042.69 | $ 5,825.17 | |||
| 2024 | $ 4,973.89 | 2024-04-02 10:35 | COSTCO DEPOT 1035 WET | 45,110.00 | 45,110.00 | $ 4,973.89 | |||
| 2024 | $ 4,973.89 | 2024-04-04 04:47 | COSTCO DEPOT 1034 DRY | 18,696.50 | 18,696.50 | $ 4,973.89 | |||
| 2024 | $ 4,973.89 | 2024-04-08 05:00 | COSTCO DEPOT 1034 DRY | 20,804.25 | 20,804.25 | $ 4,973.89 | |||
| 2024 | $ 5,825.17 | 2024-04-08 06:00 | COSTCO DEPOT 76 | 12,373.50 | 12,373.50 | $ 5,825.17 | |||
| 2024 | $ 589.07 | 2024-04-09 10:00 | COSTCO DEPOT 572 | 18,079.00 | 18,079.00 | $ 589.07 | |||
| 2024 | $ 589.07 | 2024-04-10 05:00 | COSTCO DEPOT 571 | 20,820.00 | 20,820.00 | $ 589.07 | |||
| 2024 | $ 589.07 | 2024-04-12 05:30 | COSTCO DEPOT 571 | 32,381.25 | 32,381.25 | $ 589.07 | |||
| 2024 | $ 589.07 | 2024-04-12 05:30 | COSTCO DEPOT 571 | 32,381.25 | 32,381.25 | $ 589.07 | |||
| 2024 | $ 589.07 | 2024-04-12 06:30 | COSTCO DEPOT 571 | 20,820.00 | 20,820.00 | $ 589.07 | |||
| 2024 | $ 589.07 | 2024-04-16 06:00 | COSTCO DEPOT 572 | 28,660.25 | 28,660.25 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-04-16 08:45 | COSTCO DEPOT 574 WET | 28,182.44 | 28,182.44 | $ 1,091.89 | |||
| 2024 | $ 4,973.89 | 2024-04-17 09:35 | COSTCO DEPOT 1035 WET | 24,290.00 | 24,290.00 | $ 4,973.89 | |||
| 2024 | $ 589.07 | 2024-04-19 05:30 | COSTCO DEPOT 571 | 21,337.88 | 21,337.88 | $ 589.07 | |||
| 2024 | $ 4,973.89 | 2024-04-22 06:05 | COSTCO DEPOT 1035 WET | 24,290.00 | 24,290.00 | $ 4,973.89 | |||
| 2024 | $ 589.07 | 2024-04-23 10:00 | COSTCO DEPOT 572 | 28,660.25 | 28,660.25 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-04-23 10:15 | COSTCO DEPOT 574 WET | 28,182.44 | 28,182.44 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-04-24 06:00 | COSTCO DEPOT 571 | 21,950.26 | 21,950.26 | $ 589.07 | |||
| 2024 | $ 4,973.89 | 2024-04-25 11:05 | COSTCO DEPOT 1035 WET | 34,700.00 | 34,700.00 | $ 4,973.89 | |||
| 2024 | $ 4,973.89 | 2024-04-26 11:35 | COSTCO DEPOT 1035 WET | 20,820.00 | 20,820.00 | $ 4,973.89 | |||
| 2024 | $ 589.07 | 2024-04-30 05:00 | COSTCO DEPOT 571 | 25,069.63 | 25,069.63 | $ 589.07 | |||
| 2024 | $ 4,973.89 | 2024-05-01 07:00 | COSTCO DEPOT 1034 DRY | 23,905.05 | 23,905.05 | $ 4,973.89 | |||
| 2024 | $ 5,825.17 | 2024-05-02 06:15 | COSTCO DEPOT 557 WET | 20,820.00 | 20,820.00 | $ 5,825.17 | |||
| 2024 | $ 589.07 | 2024-05-02 10:00 | COSTCO DEPOT 572 | 21,177.31 | 21,177.31 | $ 589.07 | |||
| 2024 | $ 4,973.89 | 2024-05-02 11:05 | COSTCO DEPOT 1035 WET | 24,290.00 | 24,290.00 | $ 4,973.89 | |||
| 2024 | $ 1,091.89 | 2024-05-04 08:15 | COSTCO DEPOT 574 WET | 22,720.25 | 22,720.25 | $ 1,091.89 | |||
| 2024 | $ 4,973.89 | 2024-05-06 06:05 | COSTCO DEPOT 1035 WET | 29,495.00 | 29,495.00 | $ 4,973.89 | |||
| 2024 | $ 589.07 | 2024-05-08 06:30 | COSTCO DEPOT 571 | 26,795.33 | 26,795.33 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-05-11 04:45 | COSTCO DEPOT 574 WET | 38,977.50 | 38,977.50 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-05-11 08:00 | COSTCO DEPOT 572 | 13,162.06 | 13,162.06 | $ 589.07 | |||
| 2024 | $ 4,973.89 | 2024-05-13 06:00 | COSTCO DEPOT 1034 DRY | 40,924.00 | 40,924.00 | $ 4,973.89 | |||
| 2024 | $ 5,825.17 | 2024-05-13 06:15 | COSTCO DEPOT 557 WET | 20,820.00 | 20,820.00 | $ 5,825.17 | |||
| 2024 | $ 5,825.17 | 2024-05-13 08:00 | COSTCO DEPOT 76 | 41,264.69 | 41,264.69 | $ 5,825.17 | |||
| 2024 | $ 4,973.89 | 2024-05-14 10:35 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 |