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-06-15 05:15 | COSTCO DEPOT 76 | 17,468.06 | 17,468.06 | $ 5,825.17 | ||
| 2024 | $ 4,973.89 | 2024-06-17 05:00 | COSTCO DEPOT 1034 DRY | 14,571.65 | 14,571.65 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-06-17 06:30 | COSTCO DEPOT 1034 DRY | 29,361.37 | 29,361.37 | $ 4,973.89 | ||
| 2024 | $ 5,825.17 | 2024-06-17 08:00 | COSTCO DEPOT 76 | 15,785.95 | 15,785.95 | $ 5,825.17 | ||
| 2024 | $ 4,973.89 | 2024-06-17 08:30 | COSTCO DEPOT 1034 DRY | 17,647.50 | 17,647.50 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-06-18 07:15 | COSTCO DEPOT 574 WET | 26,209.19 | 26,209.19 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-06-18 11:05 | COSTCO DEPOT 1035 WET | 34,700.00 | 34,700.00 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-06-19 06:00 | COSTCO DEPOT 572 | 21,504.69 | 21,504.69 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-06-19 10:00 | COSTCO DEPOT 572 | 10,845.00 | 10,845.00 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-06-20 09:45 | COSTCO DEPOT 574 WET | 20,629.19 | 20,629.19 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-06-20 13:00 | COSTCO DEPOT 573 DRY | 22,555.00 | 22,555.00 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-06-21 07:30 | COSTCO DEPOT 1034 DRY | 33,536.50 | 33,536.50 | $ 4,973.89 | ||
| 2024 | $ 5,825.17 | 2024-06-21 15:00 | COSTCO DEPOT 76 | 23,413.25 | 23,413.25 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-06-24 05:30 | COSTCO DEPOT 571 | 20,372.50 | 20,372.50 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-06-24 06:05 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-06-25 11:00 | COSTCO DEPOT 572 | 20,463.04 | 20,463.04 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-06-26 07:30 | COSTCO DEPOT 572 | 23,366.82 | 23,366.82 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-06-27 07:15 | COSTCO DEPOT 574 WET | 23,382.24 | 23,382.24 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-06-28 06:30 | COSTCO DEPOT 572 | 16,151.38 | 16,151.38 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-06-28 11:00 | COSTCO DEPOT 572 | 10,119.20 | 10,119.20 | $ 589.07 | ||
| 2024 | $ 5,825.17 | 2024-06-29 06:15 | COSTCO DEPOT 76 | 10,523.97 | 10,523.97 | $ 5,825.17 | ||
| 2024 | $ 4,973.89 | 2024-06-29 07:00 | COSTCO DEPOT 1034 DRY | 22,667.01 | 22,667.01 | $ 4,973.89 | ||
| 2024 | $ 5,825.17 | 2024-06-29 10:15 | COSTCO DEPOT 557 WET | 34,700.00 | 34,700.00 | $ 5,825.17 | ||
| 2024 | $ 1,091.89 | 2024-07-02 09:30 | COSTCO DEPOT 573 DRY | 21,179.71 | 21,179.71 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-07-03 06:00 | COSTCO DEPOT 572 | 15,687.70 | 15,687.70 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-07-05 10:00 | COSTCO DEPOT 572 | 20,913.69 | 20,913.69 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-07-05 10:30 | COSTCO DEPOT 1034 DRY | 38,801.89 | 38,801.89 | $ 4,973.89 | ||
| 2024 | $ 5,825.17 | 2024-07-06 09:15 | COSTCO DEPOT 76 | 26,372.90 | 26,372.90 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-07-08 05:30 | COSTCO DEPOT 571 | 22,880.58 | 22,880.58 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-07-08 06:00 | COSTCO DEPOT 1034 DRY | 31,435.28 | 31,435.28 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-07-08 07:15 | COSTCO DEPOT 574 WET | 15,844.75 | 15,844.75 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-07-08 08:45 | COSTCO DEPOT 574 WET | 16,487.27 | 16,487.27 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-07-08 09:30 | COSTCO DEPOT 573 DRY | 33,767.14 | 33,767.14 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-07-11 06:00 | COSTCO DEPOT 1034 DRY | 11,210.90 | 11,210.90 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-07-11 07:00 | COSTCO DEPOT 573 DRY | 22,972.57 | 22,972.57 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-07-11 11:35 | COSTCO DEPOT 1035 WET | 20,820.00 | 20,820.00 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-07-12 05:00 | COSTCO DEPOT 1034 DRY | 13,301.52 | 13,301.52 | $ 4,973.89 | ||
| 2024 | $ 5,825.17 | 2024-07-13 07:15 | COSTCO DEPOT 76 | 13,985.42 | 13,985.42 | $ 5,825.17 | ||
| 2024 | $ 1,091.89 | 2024-07-13 11:30 | COSTCO DEPOT 573 DRY | 26,025.00 | 26,025.00 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-07-15 05:00 | COSTCO DEPOT 571 | 20,820.00 | 20,820.00 | $ 589.07 | ||
| 2024 | $ 5,825.17 | 2024-07-15 08:15 | COSTCO DEPOT 557 WET | 20,820.00 | 20,820.00 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-07-16 06:30 | COSTCO DEPOT 571 | 23,653.76 | 23,653.76 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-07-16 07:30 | COSTCO DEPOT 1034 DRY | 18,544.70 | 18,544.70 | $ 4,973.89 | ||
| 2024 | $ 5,825.17 | 2024-07-17 07:00 | COSTCO DEPOT 76 | 21,488.13 | 21,488.13 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-07-19 07:30 | COSTCO DEPOT 572 | 30,703.73 | 30,703.73 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-07-19 09:15 | COSTCO DEPOT 574 WET | 21,797.06 | 21,797.06 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-07-19 09:36 | COSTCO DEPOT 573 DRY | 33,707.21 | 33,707.21 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-07-19 10:00 | COSTCO DEPOT 572 | 17,405.02 | 17,405.02 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-07-19 10:35 | COSTCO DEPOT 1035 WET | 24,290.00 | 24,290.00 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-07-20 06:45 | COSTCO DEPOT 574 WET | 21,452.70 | 21,452.70 | $ 1,091.89 |