Exclude blanks when using the GENERATESERIES function

Hi Neiners,
Thank you for reaching out to the Microsoft Fabric Community Forum.

I’ve taken the time to reproduce your scenario using sample data based on your description. I was able to achieve the expected output:

• MAC addresses separated by line feeds (UNICHAR(10)),
• Skipping blank PathColumn values (to avoid GENERATESERIES errors),
• Returning multiple matching values from Table2 using FILTER instead of LOOKUPVALUE.

The measure works as expected and correctly returns MAC address matches and related values from another table, even when multiple matches exist.

For your reference, I’ve attached a .pbix file demonstrating the complete setup with:

• Sample data in Table1 and Table2
• The working DAX measure
• A visual showing the output

Please feel free to explore and adapt it to your actual dataset.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.