Creating a measure to to capture items I want to exclude from my dashboard results

[Benjy83]

Hi,

I would like to create a measure that captures key words in a cell from a column that I want to exclude from my dashboard results.

eg - If a cell from the column contains "Copy" or "Duplicate" or "Test" I would like my measure to capture these and give me the option of filtering these out.

Any help would be great?!

Thanks,

Ben

[v-juanli-msft · Accepted solution]

Hi @Benjy83

Per your requirement,

Create a measure

Measure_capture = SWITCH (
TRUE (),
SEARCH ( "Copy", MAX(Table1[column]), 1, 0 ) > 0, TRUE(),
SEARCH ( "Duplicate", MAX(Table1[column]), 1, 0 ) > 0, TRUE(),
SEARCH ( "Test", MAX(Table1[column]), 1, 0 ) > 0, TRUE(),
FALSE()
)

Then add this measure in the Visual level filter as below

Best Regards

Maggie

[dedelman_clng]

Sounds more like you want to do a calculated column that returns True/False

Exclude =
SWITCH ( 
   TRUE (), 
   SEARCH ( "Copy", Table[TextCol], 1, 0 ) > 0, TRUE(),
   SEARCH ( "Duplicate", Table[TextCol], 1, 0 ) > 0, TRUE(),
   SEARCH ( "Test", Table[TextCol], 1, 0 ) > 0, TRUE(),
   FALSE()
)

Then you can filter on Exclude = FALSE (in visual, page or report headers, or within measures) to only show the records you want to see.

Hope this helps

David