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?
Thanks in advance!
Go to 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)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.