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 | $ 1,091.89 | 2024-08-26 08:30 | COSTCO DEPOT 573 DRY | 32,050.26 | 32,050.26 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-08-27 06:00 | COSTCO DEPOT 1034 DRY | 17,745.44 | 17,745.44 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-08-27 07:30 | COSTCO DEPOT 571 | 25,446.60 | 25,446.60 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-08-27 09:00 | COSTCO DEPOT 572 | 27,401.26 | 27,401.26 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-08-28 10:30 | COSTCO DEPOT 573 DRY | 45,110.00 | 45,110.00 | $ 1,091.89 | ||
| 2024 | $ 5,825.17 | 2024-08-29 07:00 | COSTCO DEPOT 76 | 25,299.01 | 25,299.01 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-08-29 08:30 | COSTCO DEPOT 571 | 31,230.00 | 31,230.00 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-08-30 10:45 | COSTCO DEPOT 574 WET | 19,099.88 | 19,099.88 | $ 1,091.89 | ||
| 2024 | $ 4,973.89 | 2024-09-03 09:05 | COSTCO DEPOT 1035 WET | 31,230.00 | 31,230.00 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-09-03 10:00 | COSTCO DEPOT 1034 DRY | 39,813.84 | 39,813.84 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-09-05 06:00 | COSTCO DEPOT 571 | 22,611.57 | 22,611.57 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-09-06 07:00 | COSTCO DEPOT 573 DRY | 32,459.75 | 32,459.75 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-09-06 08:15 | COSTCO DEPOT 574 WET | 25,455.54 | 25,455.54 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-09-06 09:00 | COSTCO DEPOT 572 | 22,667.01 | 22,667.01 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-09-06 11:05 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-09-07 08:00 | COSTCO DEPOT 1034 DRY | 32,994.03 | 32,994.03 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-09-10 08:30 | COSTCO DEPOT 572 | 26,097.04 | 26,097.04 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-09-11 07:00 | COSTCO DEPOT 571 | 26,130.09 | 26,130.09 | $ 589.07 | ||
| 2024 | $ 5,825.17 | 2024-09-11 08:45 | COSTCO DEPOT 557 WET | 24,290.00 | 24,290.00 | $ 5,825.17 | ||
| 2024 | $ 1,091.89 | 2024-09-11 10:30 | COSTCO DEPOT 573 DRY | 31,230.00 | 31,230.00 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-09-12 09:45 | COSTCO DEPOT 574 WET | 18,739.06 | 18,739.06 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-09-12 10:00 | COSTCO DEPOT 572 | 14,691.38 | 14,691.38 | $ 589.07 | ||
| 2024 | $ 589.07 | 2024-09-13 09:00 | COSTCO DEPOT 572 | 37,487.37 | 37,487.37 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-09-13 09:15 | COSTCO DEPOT 574 WET | 34,907.96 | 34,907.96 | $ 1,091.89 | ||
| 2024 | $ 5,825.17 | 2024-09-13 10:15 | COSTCO DEPOT 557 WET | 20,820.00 | 20,820.00 | $ 5,825.17 | ||
| 2024 | $ 4,973.89 | 2024-09-13 11:05 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-09-14 05:30 | COSTCO DEPOT 571 | 19,085.00 | 19,085.00 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-09-16 06:00 | COSTCO DEPOT 1034 DRY | 21,972.77 | 21,972.77 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-09-16 06:05 | COSTCO DEPOT 1035 WET | 27,760.00 | 27,760.00 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-09-16 06:30 | COSTCO DEPOT 572 | 27,203.10 | 27,203.10 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-09-16 07:00 | COSTCO DEPOT 573 DRY | 33,175.15 | 33,175.15 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-09-16 10:15 | COSTCO DEPOT 574 WET | 23,892.80 | 23,892.80 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-09-17 06:00 | COSTCO DEPOT 571 | 28,288.85 | 28,288.85 | $ 589.07 | ||
| 2024 | $ 5,825.17 | 2024-09-18 06:00 | COSTCO DEPOT 76 | 20,090.38 | 20,090.38 | $ 5,825.17 | ||
| 2024 | $ 4,973.89 | 2024-09-18 06:00 | COSTCO DEPOT 1034 DRY | 25,220.28 | 25,220.28 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-09-18 10:35 | COSTCO DEPOT 1035 WET | 26,025.00 | 26,025.00 | $ 4,973.89 | ||
| 2024 | $ 4,973.89 | 2024-09-19 08:30 | COSTCO DEPOT 1034 DRY | 21,047.94 | 21,047.94 | $ 4,973.89 | ||
| 2024 | $ 589.07 | 2024-09-19 10:00 | COSTCO DEPOT 572 | 9,503.25 | 9,503.25 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-09-19 10:15 | COSTCO DEPOT 574 WET | 9,557.81 | 9,557.81 | $ 1,091.89 | ||
| 2024 | $ 1,091.89 | 2024-09-20 06:45 | COSTCO DEPOT 574 WET | 34,581.27 | 34,581.27 | $ 1,091.89 | ||
| 2024 | $ 5,825.17 | 2024-09-20 09:00 | COSTCO DEPOT 76 | 21,047.94 | 21,047.94 | $ 5,825.17 | ||
| 2024 | $ 589.07 | 2024-09-20 12:00 | COSTCO DEPOT 571 | 20,356.69 | 20,356.69 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-09-21 05:30 | COSTCO DEPOT 573 DRY | 24,342.56 | 24,342.56 | $ 1,091.89 | ||
| 2024 | $ 5,825.17 | 2024-09-23 09:00 | COSTCO DEPOT 76 | 30,739.46 | 30,739.46 | $ 5,825.17 | ||
| 2024 | $ 1,091.89 | 2024-09-25 07:45 | COSTCO DEPOT 574 WET | 25,219.98 | 25,219.98 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-09-25 10:00 | COSTCO DEPOT 572 | 18,743.69 | 18,743.69 | $ 589.07 | ||
| 2024 | $ 4,973.89 | 2024-09-25 11:05 | COSTCO DEPOT 1035 WET | 41,640.00 | 41,640.00 | $ 4,973.89 | ||
| 2024 | $ 1,091.89 | 2024-09-26 06:30 | COSTCO DEPOT 573 DRY | 22,912.72 | 22,912.72 | $ 1,091.89 | ||
| 2024 | $ 589.07 | 2024-09-26 09:00 | COSTCO DEPOT 572 | 10,119.20 | 10,119.20 | $ 589.07 | ||
| 2024 | $ 1,091.89 | 2024-09-27 06:30 | COSTCO DEPOT 573 DRY | 39,534.07 | 39,534.07 | $ 1,091.89 |