measure or column to count numeric/alphabet characters

[Liamp]

Hello,

I've got a column of data which contains cells that are either numeric or a combination of alpha-numeric.

What I'like to do is to have a measure that looks at the column and does a count of how many cells only contain numeric characters and how many are alpha- numeric. I would display the count of these on two separate cards.

I couldn't work out a way to calculate with a measure cells containing any characters from [A-Z]. If it's not possible is there a good solution to create a calcuated column?

Thankyou

[v-stephen-msft · Accepted solution]

Hi @Liamp ,

Try to create two measure.

alpha- numeric = COUNTROWS(FILTER('Table',IFERROR(VALUE([Lesson]),BLANK())=BLANK()))

only contain numeric = COUNTROWS(FILTER('Table',IFERROR(VALUE('Table'[Lesson]),BLANK())<>BLANK()))

Best Regards,

Stephen Tao

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

[Liamp]

Sorry forgot to include some dummy data.

[Thennarasu_R]

Try in countIF Function