Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
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?
It is very strange i think. As the formula looks correct to me.
I set them both to whole numbers as the formatting
Hmm. There's an error.
@Anonymous I hope it will work with "account number in normal slicer" and "account balance" in card visual.
Hi, let's see if this works:
Calculate(sum('Table'[amountInBaseCurrency]),FILTER('Table', 'Table'[accountNumber] = "5520"))
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |