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 ...
Need Help
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.