Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |