Want to return the single value.

[Anonymous]

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 number = 60105001.

Expected results
Returns Total Amount = 72,900.00 for all 3 Rows.

How do I write the formula?

[RossEdwards]

Try the below.  I didn't know your table's name, so i have called it "YourTable"

TotalAmount from AccCode = var AccountCode = [Account Code]
var output = CALCULATE(
    SUM('YourTable'[Total Amount]),
    ALL('YourTable'),
    'YourTable'[Account Code] = AccountCode
)
RETURN
output

[Anonymous]

The value obtained is a sum of sums, still not what I want.

What I want is for all 3 Rows. to have the same value: 72,900.00, which is based on Account = 60105001 as shown in the picture above.

Can you help me again?

Write formula

Result formula

[RossEdwards]

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"

[Anonymous]

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

[RossEdwards · Accepted solution]

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]

The results were as expected.

Write formula

Result formula

Very Thankful.