Need help with a formula

[tobkres]

I need to create a formula that summarize numbers in table based on column text i decide.

This is my table

I want it to do this:

accountNumber = 5520 summarize "amountInBaseCurrency"

This should take all 5520 cells in "accountNumber" and summarize the value in "amountInBaseCurrency"

Any idea how i can do that?

The output would be sum of all values in "amountInBaseCurrency", but only those that have 5520 in "accountNumber" 

All help is appreciated.

Thanks

[tobkres]

I just did some more testing, and it seems like it works if i set "accountNumber" to format as TEXT - but that does not look logically correct to me, as account number is a "number"?

Is there a way i can format it in the function, without having to format the whole table?

[tobkres]

It is very strange i think. As the formula looks correct to me.

[tobkres]

I set them both to whole numbers as the formatting

 

[tobkres]

Hmm. There's an error.

[Karthik12]

@tobkres I hope it will work with "account number in normal slicer" and "account balance" in card visual.

[PowerUserR]

Hi, let's see if this works:
Calculate(sum('Table'[amountInBaseCurrency]),FILTER('Table', 'Table'[accountNumber] = "5520"))