Forum Discussion

JayKarim's avatar
JayKarim
Frequent Visitor
4 years ago

Help - Count of Rows which contain text

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  

Need Help

2 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.