Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
apmulhearn
Helper III
Helper III

Help with a concatenate measure which ignores blank values

Hello,

 

I have a table which contains data for people travelling together. I am trying to produce a table visual which combines the email addresses of all persons on the same trip on one line. I have one working, BUT, if a traveller does not have an email address, it comes back null and includes a semicolon. I would like them ignored completely.

Below is a screenshot of my measure and how it is currently performing. The green circled items are what I would like to avoid.

apmulhearn_0-1685109085563.png


Sample Data:

Trip CodeEmail
123456amanda@gmail.com
123456 
123456earnest@gmail.com
987654bertha@gmail.com
987654patrick@gmail.com
987654ashley@gmail.com

 

Goal Result:

Trip CodeEmails
987654bertha@gmail.com;patrick@gmail.com;ashley@gmail.com;
123456amanda@gmail.com;earnest@gmail.com
1 REPLY 1
Anonymous
Not applicable

Hi @apmulhearn ,

 

I think you can try code as below to create a measure.

EmailLis =
VAR _COMBINE =
    CONCATENATEX (
        FILTER ( 'Table', 'Table'[Email] <> BLANK () ),
        'Table'[Email],
        ";"
    )
RETURN
    IF ( _COMBINE = ";", BLANK (), _COMBINE )

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors