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,
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 | 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
)
) > 0
Regards,
Xiaoxin Sheng