Display only the specific text and remove duplicate text

[vinothkumar1990]

Hi,

I have two columns in a dataset called ID and Message. Message contains multiple lines and each line represent a specific message.

My requirement is

1. I want to show the data(line) only that cotains two specific key words i.e. M-3 or Error.

2. Sometime there couls be duplicate line items. In such case i want to show only distinct value

Below is a example. Is there anywat to achive this?

Examples:

ID	Message	Expected Message
1	M-1: Message1. M-2: Message2. M-3: Error. Message3.	M-3: Error. Message3.
2	M-3: Error. Message3.	M-3: Error. Message3.
3	M-1: Message1. M-2: Message2. M-3: Message3. M-4: Message4.	M-3: Message3.
4	M-1: Message1. M-2: Message2. M-4: Error.	M-4: Error.
4	M-4: Error. M-4: Error.	M-4: Error.

Thanks in advance!

[v-jianboli-msft · Accepted solution]

Hi @vinothkumar1990 ,

Please try to apply the measure to the visual level's filter:

Flag = IF(OR(CONTAINSSTRING(SELECTEDVALUE('Table'[Message]),"M-3"),CONTAINSSTRING(SELECTEDVALUE('Table'[Message]),"Error")),1,0)

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.