How to Add and Subtract in the same measure

[thomas_coltrain]

Hey,

So my goal here is I need to Add and Subtract in the same measure.

I have a Total Price that I need to add with a Line Amount - Credit Amount:  TotalPrice - (Line Amount + Credit Amount) = what i need

So my theory was...

SUM('Job_Planning_Lines'[Total_Price]) - SUM(('Posted_Sales_Invoice_ExcelSalesInvLines'[Line_Amount]) + SUM(Detailed_Customer_Ledger_Entries_Excel[Credit_Amount]))

This would not work for me, any clues on this?  Let me know if more info is needed on this 

Thanks!

Thomas

[thomas_coltrain]

Thanks everyone was able to get it to work!

[jppv20]

Hi @thomas_coltrain ,

This looks a wrong placement of the brackets, you could try this:

SUM('Job_Planning_Lines'[Total_Price]) - (SUM('Posted_Sales_Invoice_ExcelSalesInvLines'[Line_Amount]) + SUM(Detailed_Customer_Ledger_Entries_Excel[Credit_Amount]))

If this does not solve the problem could you please provide some example data from your tables?

Jori

If I answered your question, please mark it as a solution to help other members find it more quickly.

[PaulDBrown]

How is your model set up? What kind of visual do you want to put the measure in?

Can you supply a sample PBIX file (without confifential information) or sample data from all tables in tabular form (not images)

[AlexisOlson · Accepted solution]

The parentheses need to be outside of your second SUM.

SUM('Job_Planning_Lines'[Total_Price]) - (SUM('Posted_Sales_Invoice_ExcelSalesInvLines'[Line_Amount]) + SUM(Detailed_Customer_Ledger_Entries_Excel[Credit_Amount]))