Count of numbers in a text field

[vkomarag]

Hi All,

 I have a column with text and numbers. I need to count of only numbers in that field.

I am trying to use FILTER but it's throwing error that it cannot support comparing values of type TEXT with values of type INTEGER.

Is there any way that i can do this?

Example:

Column1:

A

B

1

2

3

4

5

Here, I need to count only where column1=2

Thanks

KVB

[Vvelarde]

@vkomarag

Hi,

 You can use the filter using column1="2"

[Anonymous]

Count all of the values that are numbers:

CountFunction = Calculate(
	count('Table'[Column1]),
	isNumber('Table'[Column1])
)

Count all of the values that equal 2:

CountFunction = Calculate(
	count('Table'[Column1]),
	'Table'[Column1] = 2
)

[vkomarag]

I got blank values for the below formula

CountFunction = Calculate(
	count('Table'[Column1]),
	isNumber('Table'[Column1])
)

[Vvelarde]

@Anonymous

The measures only works if column1 are Number Type.

[Anonymous]

Ah rats. Good point.

[Vvelarde]

@vkomarag

hi, The first try with:

CountFunction =
CALCULATE (
    COUNT ( 'Table2'[Column1] ),
    NOT ( ISERROR ( VALUE ( 'Table2'[Column1] ) ) )
)

[vkomarag]

I got the same error.

[Vvelarde · Accepted solution]

@vkomarag

My answer was for this Question:

have a column with text and numbers. I need to count of only numbers in that field.

Now, if you need to count only the rows with value 2.

Do this:

MyMeasure=Countrows(Filter(Table,Table[Column1]="2"))

[vkomarag]

Yes. It worked. Thank you.

[Anonymous]

These nice folks are trying to help, but I'm going with... "seriously?".   Feels like you should redesign your table/model, cuz that is just WEIRD.

[vkomarag]

VARCHAR datatype and and internal conversions are common everywhere. Because of Power BI cannot process my data , I can't change my model.