COUNTROWS based on number of characters

[Boycie92]

Hi,

I’m hoping someone can help.

Can anyone tell me how to replicate a count rows measure based on wildcards.

I want to count how many terms I have within a field that contains 5 characters.  In excel I would use ”?????”

https://exceljet.net/formula/count-cells-that-contain-five-characters

I have made an attempt but because it’s actually looking for the term “?????” I get zero results

Measure = CALCULATE(COUNTROWS(Table1), Table1[Code] = "A", Table[Type] = “?????”)

Thanks,

Boycie92

[Anonymous · Accepted solution]

You can just check the field length:

Measure = CALCULATE(COUNTROWS(Table1), LEN(Table1[Column]) = 5)