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-05-14 11:00 | COSTCO DEPOT 572 | 22,667.00 | 22,667.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-05-15 07:30 | COSTCO DEPOT 572 | 32,737.50 | 32,737.50 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-05-15 07:45 | COSTCO DEPOT 574 WET | 22,667.00 | 22,667.00 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-05-15 08:45 | COSTCO DEPOT 574 WET | 32,737.50 | 32,737.50 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-05-15 11:00 | COSTCO DEPOT 572 | 32,737.50 | 32,737.50 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-05-17 07:00 | COSTCO DEPOT 572 | 11,333.50 | 11,333.50 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-05-18 08:00 | COSTCO DEPOT 572 | 11,333.50 | 11,333.50 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-05-18 08:00 | COSTCO DEPOT 574 WET | 11,333.50 | 11,333.50 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-05-21 07:45 | COSTCO DEPOT 574 WET | 11,333.50 | 11,333.50 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-05-21 10:00 | COSTCO DEPOT 572 | 22,667.01 | 22,667.01 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-05-21 11:05 | COSTCO DEPOT 1035 WET | 31,230.00 | 31,230.00 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-05-21 11:05 | COSTCO DEPOT 1035 WET | 31,230.00 | 31,230.00 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-05-22 05:30 | COSTCO DEPOT 571 | 22,340.82 | 22,340.82 | $ 589.07 | ||
| 2024 | $ 5,825.17 | 2024-05-22 08:45 | COSTCO DEPOT 557 WET | 34,700.00 | 34,700.00 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-05-23 07:30 | COSTCO DEPOT 571 | 45,110.00 | 45,110.00 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-05-23 11:00 | COSTCO DEPOT 572 | 27,172.25 | 27,172.25 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-05-24 06:00 | COSTCO DEPOT 572 | 14,322.69 | 14,322.69 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-05-24 07:45 | COSTCO DEPOT 574 WET | 20,615.31 | 20,615.31 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-05-24 08:15 | COSTCO DEPOT 574 WET | 11,333.50 | 11,333.50 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-05-24 11:00 | COSTCO DEPOT 572 | 23,212.56 | 23,212.56 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-05-25 09:00 | COSTCO DEPOT 1034 DRY | 25,961.85 | 25,961.85 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-05-27 08:35 | COSTCO DEPOT 1035 WET | 31,230.00 | 31,230.00 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-05-27 09:45 | COSTCO DEPOT 574 WET | 19,006.50 | 19,006.50 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-05-27 11:00 | COSTCO DEPOT 572 | 19,798.44 | 19,798.44 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-05-28 11:00 | COSTCO DEPOT 572 | 11,333.50 | 11,333.50 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-05-30 07:30 | COSTCO DEPOT 572 | 15,838.75 | 15,838.75 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-05-30 07:45 | COSTCO DEPOT 574 WET | 20,889.75 | 20,889.75 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-05-30 08:45 | COSTCO DEPOT 574 WET | 17,422.63 | 17,422.63 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-05-30 11:00 | COSTCO DEPOT 572 | 21,914.75 | 21,914.75 | $ 589.07 | ||
| 2024 | $ 5,825.17 | 2024-05-31 06:00 | COSTCO DEPOT 76 | 12,126.50 | 12,126.50 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-06-03 05:00 | COSTCO DEPOT 571 | 20,580.82 | 20,580.82 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-06-03 06:00 | COSTCO DEPOT 572 | 18,623.00 | 18,623.00 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-06-03 10:35 | COSTCO DEPOT 1035 WET | 34,700.00 | 34,700.00 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-06-04 07:45 | COSTCO DEPOT 574 WET | 21,877.79 | 21,877.79 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-06-04 11:00 | COSTCO DEPOT 572 | 18,214.56 | 18,214.56 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-06-05 05:00 | COSTCO DEPOT 1034 DRY | 21,492.25 | 21,492.25 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-06-06 07:30 | COSTCO DEPOT 572 | 10,581.25 | 10,581.25 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-06-06 09:30 | COSTCO DEPOT 572 | 16,190.72 | 16,190.72 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-06-06 09:45 | COSTCO DEPOT 574 WET | 12,143.04 | 12,143.04 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-06-07 11:00 | COSTCO DEPOT 572 | 13,529.50 | 13,529.50 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-06-10 09:15 | COSTCO DEPOT 574 WET | 25,538.25 | 25,538.25 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-06-11 06:30 | COSTCO DEPOT 572 | 18,214.56 | 18,214.56 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-06-11 10:00 | COSTCO DEPOT 572 | 28,143.69 | 28,143.69 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-06-11 11:05 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-06-13 07:30 | COSTCO DEPOT 572 | 17,472.00 | 17,472.00 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-06-13 09:15 | COSTCO DEPOT 574 WET | 31,233.54 | 31,233.54 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-06-13 11:00 | COSTCO DEPOT 572 | 16,190.72 | 16,190.72 | $ 589.07 | ||
| 2024 | $ 5,825.17 | 2024-06-13 11:45 | COSTCO DEPOT 557 WET | 34,700.00 | 34,700.00 | $ 5,825.17 | ||
| 2024 | $ 1,091.89 | 2024-06-14 07:45 | COSTCO DEPOT 574 WET | 26,259.63 | 26,259.63 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-06-14 10:00 | COSTCO DEPOT 572 | 23,850.30 | 23,850.30 | $ 589.07 |