Forum Discussion
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 ...
CALCULATE(
[SalesAmount],
FILTER( NOT CONTAINSSTRING( 'Table'[ColumnName], 'SAMPLE') )
)
CONTAINSSTRING function (DAX) - DAX | Microsoft Learn
CALCULATE(
[SalesAmount],
FILTER( NOT CONTAINSSTRING( 'Table'[ColumnName], 'SAMPLE') )
)
CONTAINSSTRING function (DAX) - DAX | Microsoft Learn
Hello Thomas,
Thanks, It worked!.