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-12-10 06:00 | COSTCO DEPOT 571 | 25,360.00 | 25,360.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-12-11 12:00 | COSTCO DEPOT 572 | 25,786.00 | 25,786.00 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-12-12 09:45 | COSTCO DEPOT 574 WET | 24,723.88 | 24,723.88 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-12-12 10:30 | COSTCO DEPOT 573 DRY | 29,121.25 | 29,121.25 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-12-12 14:00 | COSTCO DEPOT 571 | 20,820.00 | 20,820.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-12-13 11:00 | COSTCO DEPOT 572 | 27,453.57 | 27,453.57 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-12-14 07:00 | COSTCO DEPOT 571 | 20,820.00 | 20,820.00 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-12-14 09:30 | COSTCO DEPOT 573 DRY | 38,170.00 | 38,170.00 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-12-16 10:05 | COSTCO DEPOT 1035 WET | 34,700.00 | 34,700.00 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-12-17 05:00 | COSTCO DEPOT 571 | 31,182.81 | 31,182.81 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-12-17 10:15 | COSTCO DEPOT 574 WET | 24,148.80 | 24,148.80 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-12-19 05:30 | COSTCO DEPOT 571 | 29,495.00 | 29,495.00 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-12-19 08:00 | COSTCO DEPOT 573 DRY | 29,895.11 | 29,895.11 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-12-19 10:35 | COSTCO DEPOT 1035 WET | 41,640.00 | 41,640.00 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-12-19 12:00 | COSTCO DEPOT 572 | 15,042.13 | 15,042.13 | $ 589.07 | ||
| 2024 | $ 5,825.17 | 2024-12-20 09:45 | COSTCO DEPOT 557 WET | 27,760.00 | 27,760.00 | $ 5,825.17 | ||
| 2024 | $ 1,091.89 | 2024-12-20 10:15 | COSTCO DEPOT 574 WET | 16,698.50 | 16,698.50 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-12-27 12:00 | COSTCO DEPOT 572 | 15,812.39 | 15,812.39 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-12-28 06:45 | COSTCO DEPOT 574 WET | 16,570.01 | 16,570.01 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-12-28 08:30 | COSTCO DEPOT 573 DRY | 24,564.15 | 24,564.15 | $ 1,091.89 | ||
| 2025 | $ 589.07 | 2025-01-03 10:00 | COSTCO DEPOT 572 | 10,935.80 | 10,935.80 | $ 589.07 | ||
| 2025 | $ 4,973.89 | 2025-01-06 05:30 | COSTCO DEPOT 1034 DRY | 29,001.00 | 29,001.00 | $ 4,973.89 | ||
| 2025 | $ 4,973.89 | 2025-01-06 07:00 | COSTCO DEPOT 1034 DRY | 29,477.92 | 29,477.92 | $ 4,973.89 | ||
| 2025 | $ 1,091.89 | 2025-01-06 11:30 | COSTCO DEPOT 573 DRY | 13,880.00 | 13,880.00 | $ 1,091.89 | ||
| 2025 | $ 5,835.07 | 2025-01-06 12:00 | COSTCO DEPOT 76 | 40,523.44 | 40,523.44 | $ 5,835.07 | ||
| 2025 | $ 4,973.89 | 2025-01-10 11:05 | COSTCO DEPOT 1035 WET | 20,820.00 | 20,820.00 | $ 4,973.89 | ||
| 2025 | $ 4,973.89 | 2025-01-13 09:35 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | ||
| 2025 | $ 1,091.89 | 2025-01-13 10:15 | COSTCO DEPOT 574 WET | 15,687.43 | 15,687.43 | $ 1,091.89 | ||
| 2025 | $ 589.07 | 2025-01-14 05:00 | COSTCO DEPOT 571 | 32,266.65 | 32,266.65 | $ 589.07 | ||
| 2025 | $ 4,973.89 | 2025-01-17 07:30 | COSTCO DEPOT 1034 DRY | 15,482.54 | 15,482.54 | $ 4,973.89 | ||
| 2025 | $ 589.07 | 2025-01-17 11:00 | COSTCO DEPOT 572 | 14,304.21 | 14,304.21 | $ 589.07 | ||
| 2025 | $ 1,091.89 | 2025-01-18 06:00 | COSTCO DEPOT 573 DRY | 25,275.19 | 25,275.19 | $ 1,091.89 | ||
| 2025 | $ 589.07 | 2025-01-20 05:00 | COSTCO DEPOT 571 | 45,253.89 | 45,253.89 | $ 589.07 | ||
| 2025 | $ 589.07 | 2025-01-20 05:30 | COSTCO DEPOT 571 | 43,650.00 | 43,650.00 | $ 589.07 | ||
| 2025 | $ 1,091.89 | 2025-01-20 08:00 | COSTCO DEPOT 573 DRY | 43,650.00 | 43,650.00 | $ 1,091.89 | ||
| 2025 | $ 1,091.89 | 2025-01-20 08:30 | COSTCO DEPOT 573 DRY | 43,650.00 | 43,650.00 | $ 1,091.89 | ||
| 2025 | $ 589.07 | 2025-01-24 09:00 | COSTCO DEPOT 572 | 36,960.62 | 36,960.62 | $ 589.07 | ||
| 2025 | $ 1,091.89 | 2025-01-24 10:15 | COSTCO DEPOT 574 WET | 33,000.55 | 33,000.55 | $ 1,091.89 | ||
| 2025 | $ 589.07 | 2025-01-24 12:00 | COSTCO DEPOT 572 | 7,139.80 | 7,139.80 | $ 589.07 | ||
| 2025 | $ 1,091.89 | 2025-01-27 06:30 | COSTCO DEPOT 573 DRY | 6,950.51 | 6,950.51 | $ 1,091.89 |