Forum Discussion

kwhite0510's avatar
kwhite0510
Frequent Visitor
2 years ago
Solved

Row summation

I have a column with "PO Agreement Price/TN" in which I need to add the other costing mark ups based on the criteria "550P04 and 550P08" as show in the data snapshot below. Looking for a total of $47...
Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, kwhite0510 

     

    You can try the following methods.

    Measure = CALCULATE(SUM('Table'[Costing markup]),ALLEXCEPT('Table','Table'[PO Agreement Price/TN]))
    Result = SUM('Table'[PO Agreement Price/TN])+[Measure]

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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