Help - Count of Rows which contain text

[JayKarim]

Morning all, 

I have created a score card, this counts cells in a specific column that contains a 'claim reference number. 

The scorecard isn't picking up the claim Reference which has text in it. It picks up cells that have numbers only.

How do I get round this problem so it also counts cells with text and numbers?

Many thanks in advance

Jay  

[v-stephen-msft]

Hi @JayKarim ,

Please try to use the COUNTROWS function. It counts the number of rows in the specified table, or in a table defined by an expression.

COUNTROWS([<table>])  

COUNTROWS function (DAX) - DAX | Microsoft Docs

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.

[tamerj1]

Hi @JayKarim 
You can filter using COTAINSSTRING function. Please provide sample data with the expected result.