Forum Discussion

Del235's avatar
Del235
Helper III
4 months ago
Solved

Filtering Emails

I've created a table that contains email addresses and I don't want to include certain domains.  If I have addresses that appear as [email protected], I've used an Filter Type : Advanced Filter and Sh...
Need Help
  • v-moharafi-msft's avatar
    v-moharafi-msft
    3 months ago

    Hi Del235 ,

     

    I tried to recreate your scenario in Power BI, and on my end the “Does not contain test.com” filter is working as expected. This usually indicates that the behavior might be related to how the data is formatted rather than the filter logic itself. 

     

    First, you can check for hidden spaces or characters in the email values, as these can sometimes affect filtering. You can validate this by creating a column like Length = LEN(YourTable[Email]) if similar emails return different lengths, it likely means there are trailing spaces or invisible characters. 

     

    Secondly, avoid such issues, you can clean and standardize the data by creating a column like Clean Email = LOWER(TRIM(YourTable[Email])), and then use Is Test Domain = CONTAINSSTRING([Clean Email], "test.com"). Applying the filter on this cleaned column generally resolves these inconsistencies. 

     

    Please find the screenshots below for your reference:

     

     

    Best Regards, 

    Abdul Rafi 

v-moharafi-msft's avatar
v-moharafi-msft
Community Support
3 months ago

Hi Del235  ,


We wanted to check if your question has been resolved or if you are still facing any confusion feel free to reach out. 

 

Thank you.

  • Del235's avatar
    Del235
    Helper III
    3 months ago

    Its not working for me using the filter/Does not contain

    • v-moharafi-msft's avatar
      v-moharafi-msft
      Community Support
      3 months ago

      Hi Del235 ,

       

      I tried to recreate your scenario in Power BI, and on my end the “Does not contain test.com” filter is working as expected. This usually indicates that the behavior might be related to how the data is formatted rather than the filter logic itself. 

       

      First, you can check for hidden spaces or characters in the email values, as these can sometimes affect filtering. You can validate this by creating a column like Length = LEN(YourTable[Email]) if similar emails return different lengths, it likely means there are trailing spaces or invisible characters. 

       

      Secondly, avoid such issues, you can clean and standardize the data by creating a column like Clean Email = LOWER(TRIM(YourTable[Email])), and then use Is Test Domain = CONTAINSSTRING([Clean Email], "test.com"). Applying the filter on this cleaned column generally resolves these inconsistencies. 

       

      Please find the screenshots below for your reference:

       

       

      Best Regards, 

      Abdul Rafi