Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Want to return the single value.

Hi, Everyone   I have question please help.   I want to return the Total Amount from each Sale Order No. and want the value to be the same for all 3 Rows, which is based on the Account Code numbe...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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