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 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

The results were as expected.

 

Write formula

 

Result formula

 

Very Thankful.