Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Anonymous
Not applicable

Need help with a formula

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

 

This is my table

tobkres_1-1662974496925.png

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

 

6 REPLIES 6
Anonymous
Not applicable

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?

Anonymous
Not applicable

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

Anonymous
Not applicable

I set them both to whole numbers as the formatting

tobkres_2-1663058864383.png

tobkres_3-1663058880071.png

 

Anonymous
Not applicable

Hmm. There's an error.

tobkres_1-1663058512752.png

 

 

Karthik12
Post Patron
Post Patron

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

 

Anonymous
Not applicable

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.