Forum Discussion
Filter out multiple values from a list
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
HI Anonymous ,
Maybe you can consider to add a public/company domain list to your report, then filter records based on public/company domain list.
In addition, I'd like some sample data to help us clarify your data structure for test and coding formula.
Regards,
Xiaoxin Sheng
Hi Anonymous,
Please find a short example of my data below, note that contact information is fake and not valid.
Table Name: Contact
First Name Last Name Email Phone job title Company John Doe [email protected] 555-555-5555 Director of Marketing Sony Jenny Brooks [email protected] Peter Parker [email protected] 555-555-5555 Consultant Peter Inc. Susan James [email protected] 555-555-5555 Student Kim Sullivan [email protected] Analyst HP Brenda Wozniak [email protected] 555-555-5555 Lexus Scott Wade [email protected] 555-555-5555 VP Customer services UPS Natalia hernandez [email protected] 555-555-5555 Alex Rawlings AlexRaw@aol Customer support agent Ford Patrick Kane [email protected] CX Director Verizon As with any other contact database not all fields are populated with prevents me from filtering on other values like company or title. The only required field to enter a new record in the table was an email address so filtering on the email seems like the only way to properly clean that database.
Ultimately, I want to get a table with excluding all record with a public email
Also, since in some rare occasions some public email might be relevant if other criterias are meet, I would prefer to apply the filter at the report level and not at the initial query level when importing the data from salesforce.com
I hope this can help you better understand what I am trying to get to and define the right query/measure
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