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.

kwhite0510's avatar
kwhite0510
Frequent Visitor
2 years ago

Logic would be the PO Agreement Price/TN of $469.88 + 2 costing mark up element costs (in which I show in the screenshot that I have a filter on) of $4.42 and $4 = 478.30

 

 

THe $4.42 and $4 come from a different database that I have created a direct query for. 

 

Please let me know if this helps. I appreciate you taking a look at this for me.

  • v-zhangti's avatar
    v-zhangti
    Community Support
    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.