Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |