Need help with a formula

Question

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

anonymous · Answer

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

karthik12 · Answer

Anonymous&nbsp;I hope it will work with "account number in normal slicer" and "account balance" in card visual.&nbsp;

anonymous · Answer

Hmm. There's an error.&nbsp;&nbsp;

anonymous · Answer

I set them both to whole numbers as the formatting &nbsp;

anonymous · Answer

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

Forum Discussion