Forum Discussion
Want to return the single value.
I suspect the issue here is that you have other sale order numbers that you don't want included in your formula. We just need another variable to handle that.
TotalAmount from AccCode = var AccountCode = "60105001" var SaleOrder = [Sale Order No.] var output = CALCULATE( SUM('Reconcile Back Order'[Total Amount]), ALL('Reconcile Back Order'), 'Reconcile Back Order'[Account Code] = AccountCode, 'Reconcile Back Order'[Sale Order No.] = SaleOrder ) RETURN output
Oh thats an easy fix then. In the code sample I provided to you. Change the AccountCode variable to a static account code rather than the dynamic one.
From
var AccountCode = [Account Code]to
var AccountCode = "60105001"
I have made the correction. The results obtained It's still not what you want.
But what I got is It's the same result for all 3 rows. I think I'm close to getting the correct answer. If the answer is 72,900.00 then it is correct.
Write formula
Result formula
I suspect the issue here is that you have other sale order numbers that you don't want included in your formula. We just need another variable to handle that.
TotalAmount from AccCode = var AccountCode = "60105001" var SaleOrder = [Sale Order No.] var output = CALCULATE( SUM('Reconcile Back Order'[Total Amount]), ALL('Reconcile Back Order'), 'Reconcile Back Order'[Account Code] = AccountCode, 'Reconcile Back Order'[Sale Order No.] = SaleOrder ) RETURN outputThe results were as expected.
Write formula
Result formula
Very Thankful.