Forum Discussion

GVallentgoed's avatar
GVallentgoed
Helper II
1 year ago
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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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,
    Zhu

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.                                                                                                                                                                             

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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,
Zhu

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.                                                                                                                                                                             

  • GVallentgoed's avatar
    GVallentgoed
    Helper II
    1 year ago

    Ahh I was missing the "Values" criteria!  Thanks!