Forum Discussion
Countrows in multiple column based on partial text value
Dear all, For a project I need to be able to count the number of rows in a file, based on a text value in one of eight defined columns. I want to count a row when one of the "Linked Issues" colu...
Hi LaurensM02 ,
Your DAX won't work. That is because
>= operator will work only with numbers. But you are using >= with a string value
i.e.
COUNTROWS(FILTER('Sheet1', 'Sheet1'[Linked Issues.1] >= "THGRW-000"))
In the above DAX, THGRW-000 is a string and hence cannot be used with a >= operator
You will have to use a == operator or an IN operator to compare text and count. Then sum the different conditions.
If you want more focused answer, pls. share how your output should look.
I also tried the following formula, but this results in a blank result when added to a card visual. I don't know what's wrong.