Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...
Solved! Go to 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]))
Thanks everyone was able to get it to work!
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.
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)
Proud to be a Super User!
Paul on Linkedin.
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]))
User | Count |
---|---|
106 | |
86 | |
81 | |
74 | |
71 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |