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

[SU_IN]

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.

[Anonymous · Accepted solution]

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

CONTAINSSTRING function (DAX) - DAX | Microsoft Learn

[SU_IN]

Hello Thomas,

Thanks, It worked!.

[Anonymous]

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

[SU_IN]

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.