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


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

 

How do I write the formula?

 

 

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

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

      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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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"