Forum Discussion
Filter out multiple values from a list
Hello, I have a table that containts a list of all contacts that I have exported from our CRM (salesforce.com) that I want to cleanup. I am looking to filter the list to remove all contacts that...
Hi Anonymous ,
As I said, you can add public domain table with domain text which you want to exclude.
Then add a calculated column to contact table to compare current row content with public domain table list.
Is Public = COUNTROWS ( FILTER ( ALL ( 'Pubich Domain' ), SEARCH( 'Pubich Domain'[Domain], [Email], 1, -1 ) > 0 ) ) > 0Regards,
Xiaoxin Sheng
why dont u apply filter in query editor where email domain = your company...n ignore all other...
Hello Reddy_powerBi
My list contains customer contacts so they all have different domains so what you propose is not a viable option in that case
Thanks,