dax for sum of string

[Anonymous]

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

[v-yetao1-msft · Accepted solution]

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]

@Anonymous , use countx in place of count

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

[Anonymous]

i tried count x it did work as well

[amitchandak]

@Anonymous , first argument is the table name 

refer :

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

[Anonymous]

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

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