Forum Discussion

SU_IN's avatar
SU_IN
New Member
2 years ago
Solved

DAX code to Filter column 'does not start with' a specific text

Hi,

I am trying to write a measure in DAX with CALCULATE function with a filter for a column - count the rows that does not start with 'SAMPLE'.

Can someone write DAX code here to filter for 'does not start with'

 

Thanks.

 

Need Help

4 Replies

    • SU_IN's avatar
      SU_IN
      New Member
      2 years ago

      Hello Thomas,

      Thanks, It worked!.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    CALCULATE(
      [SalesAmount],
      FILTER( NOT ('Table'[ColumnName] = 'SAMPLE')
    )

    • SU_IN's avatar
      SU_IN
      New Member
      2 years ago

      Hi,

      Thanks.

      But this one will remove (Filter) only the one with SAMPLE.

      But I have SAMPLE 1, SAMPLE ABC, SAMPLE Country etc.

      I want to remove everything that start with SAMPLE.