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 | $ 4,973.89 | 2024-07-22 11:35 | COSTCO DEPOT 1035 WET | 20,820.00 | 20,820.00 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-07-24 08:00 | COSTCO DEPOT 1034 DRY | 13,762.11 | 13,762.11 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-07-24 11:30 | COSTCO DEPOT 1034 DRY | 24,543.63 | 24,543.63 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-07-24 23:59 | COSTCO DEPOT 573 DRY | 27,040.25 | 27,040.25 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-07-25 06:00 | COSTCO DEPOT 1034 DRY | 20,560.83 | 20,560.83 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-07-25 10:00 | COSTCO DEPOT 572 | 25,355.25 | 25,355.25 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-07-26 05:30 | COSTCO DEPOT 571 | 26,208.82 | 26,208.82 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-07-26 06:00 | COSTCO DEPOT 573 DRY | 26,208.27 | 26,208.27 | $ 1,091.89 | ||
| 2024 | $ 5,825.17 | 2024-07-26 09:00 | COSTCO DEPOT 76 | 22,063.53 | 22,063.53 | $ 5,825.17 | ||
| 2024 | $ 4,973.89 | 2024-07-26 09:35 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-07-26 11:00 | COSTCO DEPOT 572 | 19,250.75 | 19,250.75 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-07-27 07:00 | COSTCO DEPOT 573 DRY | 22,384.88 | 22,384.88 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-07-30 08:30 | COSTCO DEPOT 1034 DRY | 28,493.96 | 28,493.96 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-07-30 10:00 | COSTCO DEPOT 571 | 20,820.00 | 20,820.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-07-31 06:30 | COSTCO DEPOT 571 | 26,625.70 | 26,625.70 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-07-31 11:00 | COSTCO DEPOT 572 | 22,582.69 | 22,582.69 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-08-01 10:00 | COSTCO DEPOT 572 | 18,390.25 | 18,390.25 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-08-02 06:30 | COSTCO DEPOT 572 | 9,714.43 | 9,714.43 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-08-02 09:45 | COSTCO DEPOT 574 WET | 28,836.44 | 28,836.44 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-08-02 10:00 | COSTCO DEPOT 572 | 28,836.44 | 28,836.44 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-08-02 10:00 | COSTCO DEPOT 572 | 17,410.69 | 17,410.69 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-08-06 07:00 | COSTCO DEPOT 573 DRY | 24,484.70 | 24,484.70 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-08-06 10:35 | COSTCO DEPOT 1035 WET | 24,290.00 | 24,290.00 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-08-07 07:45 | COSTCO DEPOT 574 WET | 20,647.50 | 20,647.50 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-08-09 10:45 | COSTCO DEPOT 574 WET | 27,343.56 | 27,343.56 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-08-10 05:00 | COSTCO DEPOT 1034 DRY | 37,140.20 | 37,140.20 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-08-10 07:00 | COSTCO DEPOT 573 DRY | 24,138.63 | 24,138.63 | $ 1,091.89 | ||
| 2024 | $ 5,825.17 | 2024-08-10 07:15 | COSTCO DEPOT 76 | 32,891.64 | 32,891.64 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-08-13 09:00 | COSTCO DEPOT 572 | 16,640.00 | 16,640.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-08-14 06:00 | COSTCO DEPOT 571 | 28,581.16 | 28,581.16 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-08-14 06:30 | COSTCO DEPOT 573 DRY | 21,950.83 | 21,950.83 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-08-14 08:45 | COSTCO DEPOT 574 WET | 16,640.00 | 16,640.00 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-08-14 10:35 | COSTCO DEPOT 1035 WET | 20,820.00 | 20,820.00 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-08-15 06:30 | COSTCO DEPOT 572 | 14,753.56 | 14,753.56 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-08-15 10:45 | COSTCO DEPOT 574 WET | 21,559.36 | 21,559.36 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-08-16 10:00 | COSTCO DEPOT 573 DRY | 21,932.51 | 21,932.51 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-08-16 10:00 | COSTCO DEPOT 572 | 21,894.63 | 21,894.63 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-08-19 06:30 | COSTCO DEPOT 573 DRY | 26,084.63 | 26,084.63 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-08-19 09:45 | COSTCO DEPOT 574 WET | 10,816.00 | 10,816.00 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-08-20 08:00 | COSTCO DEPOT 572 | 18,304.00 | 18,304.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-08-20 10:00 | COSTCO DEPOT 572 | 24,180.13 | 24,180.13 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-08-21 07:00 | COSTCO DEPOT 571 | 34,360.20 | 34,360.20 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-08-22 07:00 | COSTCO DEPOT 1034 DRY | 19,751.22 | 19,751.22 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-08-22 07:45 | COSTCO DEPOT 574 WET | 19,314.69 | 19,314.69 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-08-22 08:15 | COSTCO DEPOT 574 WET | 17,461.44 | 17,461.44 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-08-23 07:30 | COSTCO DEPOT 572 | 17,461.44 | 17,461.44 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-08-23 11:35 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-08-25 23:59 | COSTCO DEPOT 1035 WET | 31,230.00 | 31,230.00 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-08-26 06:00 | COSTCO DEPOT 573 DRY | 27,729.14 | 27,729.14 | $ 1,091.89 | ||
| 2024 | $ 5,825.17 | 2024-08-26 08:00 | COSTCO DEPOT 76 | 16,430.38 | 16,430.38 | $ 5,825.17 |