Forum Discussion

jammo1234's avatar
jammo1234
New Member
3 years ago
Solved

CountX with string does not contain "."

Hi all,   Bit of a newbie question here, Im trying to filter rows in the table where a row does not have a "." suffix on the end. For example the table name "Table 1" with the Column name called "...
  • Greg_Deckler's avatar
    3 years ago

    jammo1234 Try:

     

    Measure = COUNTROWS(FILTER('Table 1', NOT(CONTAINSSTRING([ElementID], "."))))

     

  • jammo1234's avatar
    3 years ago

    Thank you much appreciated