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 | $ 5,825.17 | 2024-11-04 06:00 | COSTCO DEPOT BC | 19,396.46 | 19,396.46 | $ 5,825.17 | |||
| 2024 | $ 1,091.89 | 2024-11-04 23:01 | COSTCO DEPOT 573 DRY | 31,851.94 | 31,851.94 | $ 1,091.89 | |||
| 2024 | $ 1,091.89 | 2024-11-05 10:46 | COSTCO DEPOT 574 WET | 32,626.13 | 32,626.13 | $ 1,091.89 | |||
| 2024 | $ 4,973.89 | 2024-11-06 05:00 | COSTCO DEPOT 1034 DRY | 34,500.90 | 34,500.90 | $ 4,973.89 | |||
| 2024 | $ 589.07 | 2024-11-08 11:00 | COSTCO DEPOT 572 | 12,034.27 | 12,034.27 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-11-11 10:15 | COSTCO DEPOT QC | 14,963.56 | 14,963.56 | $ 1,091.89 | |||
| 2024 | $ 1,091.89 | 2024-11-11 11:30 | COSTCO DEPOT 573 DRY | 32,294.76 | 32,294.76 | $ 1,091.89 | |||
| 2024 | $ 4,973.89 | 2024-11-12 10:35 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | |||
| 2024 | $ 589.07 | 2024-11-13 11:00 | COSTCO DEPOT 572 | 36,000.00 | 36,000.00 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-11-14 09:45 | COSTCO DEPOT 574 WET | 34,678.61 | 34,678.61 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-11-14 23:59 | COSTCO DEPOT 572 | 25,423.25 | 25,423.25 | $ 589.07 | |||
| 2024 | $ 4,973.89 | 2024-11-15 07:00 | COSTCO DEPOT 1034 DRY | 23,195.93 | 23,195.93 | $ 4,973.89 | |||
| 2024 | $ 589.07 | 2024-11-15 07:00 | COSTCO DEPOT 571 | 28,890.40 | 28,890.40 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-11-15 10:45 | COSTCO DEPOT 574 WET | 22,137.25 | 22,137.25 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-11-15 11:00 | COSTCO DEPOT 572 | 22,137.25 | 22,137.25 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-11-15 12:30 | COSTCO DEPOT 573 DRY | 34,700.00 | 34,700.00 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-11-16 08:30 | COSTCO DEPOT 571 | 26,571.26 | 26,571.26 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-11-18 23:59 | COSTCO DEPOT 573 DRY | 31,610.44 | 31,610.44 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-11-20 06:00 | COSTCO DEPOT 571 | 22,555.00 | 22,555.00 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-11-20 08:30 | COSTCO DEPOT 573 DRY | 31,230.00 | 31,230.00 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-11-21 11:00 | COSTCO DEPOT 572 | 18,072.91 | 18,072.91 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-11-22 10:30 | COSTCO DEPOT 573 DRY | 26,025.00 | 26,025.00 | $ 1,091.89 | |||
| 2024 | $ 1,091.89 | 2024-11-23 06:45 | COSTCO DEPOT 574 WET | 16,241.88 | 16,241.88 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-11-23 08:00 | COSTCO DEPOT 572 | 14,079.00 | 14,079.00 | $ 589.07 | |||
| 2024 | $ 4,973.89 | 2024-11-25 12:05 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | |||
| 2024 | $ 1,091.89 | 2024-11-26 05:00 | COSTCO DEPOT 573 DRY | 31,442.39 | 31,442.39 | $ 1,091.89 | |||
| 2024 | $ 5,825.17 | 2024-11-26 08:45 | COSTCO DEPOT 557 WET | 20,820.00 | 20,820.00 | $ 5,825.17 | |||
| 2024 | $ 589.07 | 2024-11-27 09:00 | COSTCO DEPOT 571 | 24,345.29 | 24,345.29 | $ 589.07 | |||
| 2024 | $ 589.07 | 2024-11-27 11:00 | COSTCO DEPOT 572 | 17,366.69 | 17,366.69 | $ 589.07 | |||
| 2024 | $ 589.07 | 2024-11-29 08:00 | COSTCO DEPOT 571 | 29,495.00 | 29,495.00 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-11-29 09:00 | COSTCO DEPOT 573 DRY | 26,025.00 | 26,025.00 | $ 1,091.89 | |||
| 2024 | $ 1,091.89 | 2024-11-29 10:45 | COSTCO DEPOT 574 WET | 25,116.35 | 25,116.35 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-11-29 11:00 | COSTCO DEPOT 572 | 32,038.31 | 32,038.31 | $ 589.07 | |||
| 2024 | $ 4,973.89 | 2024-11-29 11:05 | COSTCO DEPOT 1035 WET | 34,700.00 | 34,700.00 | $ 4,973.89 | |||
| 2024 | $ 1,091.89 | 2024-12-03 09:30 | COSTCO DEPOT 573 DRY | 39,225.43 | 39,225.43 | $ 1,091.89 | |||
| 2024 | $ 4,973.89 | 2024-12-03 11:05 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | |||
| 2024 | $ 589.07 | 2024-12-03 12:00 | COSTCO DEPOT 572 | 31,258.13 | 31,258.13 | $ 589.07 | |||
| 2024 | $ 589.07 | 2024-12-03 12:00 | COSTCO DEPOT 572 | 22,036.00 | 22,036.00 | $ 589.07 | |||
| 2024 | $ 589.07 | 2024-12-03 12:00 | COSTCO DEPOT 572 | 22,036.00 | 22,036.00 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-12-04 09:45 | COSTCO DEPOT 574 WET | 14,166.00 | 14,166.00 | $ 1,091.89 | |||
| 2024 | $ 1,091.89 | 2024-12-04 10:15 | COSTCO DEPOT 574 WET | 22,174.25 | 22,174.25 | $ 1,091.89 | |||
| 2024 | $ 589.07 | 2024-12-05 12:00 | COSTCO DEPOT 572 | 21,839.69 | 21,839.69 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-12-06 08:00 | COSTCO DEPOT 573 DRY | 43,120.61 | 43,120.61 | $ 1,091.89 | |||
| 2024 | $ 4,973.89 | 2024-12-06 11:05 | COSTCO DEPOT 1035 WET | 31,230.00 | 31,230.00 | $ 4,973.89 | |||
| 2024 | $ 589.07 | 2024-12-06 23:59 | COSTCO DEPOT 572 | 32,151.79 | 32,151.79 | $ 589.07 | |||
| 2024 | $ 589.07 | 2024-12-07 04:00 | COSTCO DEPOT 572 | 22,174.25 | 22,174.25 | $ 589.07 | |||
| 2024 | $ 1,091.89 | 2024-12-07 09:15 | COSTCO DEPOT 574 WET | 22,174.25 | 22,174.25 | $ 1,091.89 | |||
| 2024 | $ 1,091.89 | 2024-12-09 06:00 | COSTCO DEPOT 573 DRY | 25,360.00 | 25,360.00 | $ 1,091.89 | |||
| 2024 | $ 4,973.89 | 2024-12-09 06:05 | COSTCO DEPOT 1035 WET | 34,700.00 | 34,700.00 | $ 4,973.89 | |||
| 2024 | $ 1,091.89 | 2024-12-09 09:00 | COSTCO DEPOT 573 DRY | 44,815.00 | 44,815.00 | $ 1,091.89 |