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

dax for sum of string

hi
i am tring to sum all the pos columns the columns are in string format.
i have tried countA as well but didnt work

 

greeshma_0-1619510139791.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous 

There is a way maybe more complicated, but you can sum the strings of the entire table . Calculate the strings in each column separately and then sum these counts .

For example :

POS 1-1 = COUNTA('The export'[POS 1])

POS 2-1 = COUNTA('The export'[POS 2])

POS 3-1 = COUNTA('The export'[POS 3])

       ……………

POS 11-1 = COUNTA('The export'[POS 11])

 

And then sum these counts

Total = CALCULATE('The export'[POS 1-1]+'The export'[POS 2-1]+'The export'[POS 3-1]+……………… +'The export'[POS 11-1])

You will get the sum of strings in table .

 

Best Regards

Community Support Team _ Ailsa Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

Hi @Anonymous 

There is a way maybe more complicated, but you can sum the strings of the entire table . Calculate the strings in each column separately and then sum these counts .

For example :

POS 1-1 = COUNTA('The export'[POS 1])

POS 2-1 = COUNTA('The export'[POS 2])

POS 3-1 = COUNTA('The export'[POS 3])

       ……………

POS 11-1 = COUNTA('The export'[POS 11])

 

And then sum these counts

Total = CALCULATE('The export'[POS 1-1]+'The export'[POS 2-1]+'The export'[POS 3-1]+……………… +'The export'[POS 11-1])

You will get the sum of strings in table .

 

Best Regards

Community Support Team _ Ailsa Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Anonymous , use countx in place of count

 

countx('the export', <your current formula>)

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

i tried count x it did work as well

greeshma_0-1619511041476.pnggreeshma_1-1619511075630.png

 

@Anonymous , first argument is the table name 

 

refer :

https://theexcelclub.com/dax-count-and-countx-impact-of-using-measures-and-columns/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

i have tried first argument as countx as well
i have shared pbix file

greeshma_1-1619512083745.png

https://drive.google.com/file/d/1qZ5_7fMRh5WE_wDN3DAZFH9G0opTB2vX/view?usp=sharing

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.