Concatenate Rows with Condition - Help Please!

[Anonymous]

From the below data set I need all of a Partner IDs active (TRUE) email addresses in one cell.

Using dax I'm very close but cannot figure out how to add the condition to output only 'TRUE' (active) emails from the enabled column.  (shown in wanted results table below).

Here is what I have so far that is outputting all of a partners emails (and my table name is 

t_b2b_na_partner_user):

= calculate(CONCATENATEX(t_b2b_na_partner_user,t_b2b_na_partner_user[EMAIL],"; "),ALLEXCEPT(t_b2b_na_partner_user,t_b2b_na_partner_user[PARTNER_ID]))

Any help adding the condtion of 'TRUE' from the enabled column would be amazing - THANK YOU!!

Current Data:

Partner_ID	Email	Enabled
PCA00000054	andrea@syoga.com	TRUE
PCA00000063	ahurlburt@fitness.com	TRUE
PCA00000063	nkeane@fitness.com	FALSE
PCA0000007	teginpopowich@hotmail.com	TRUE
PCA0000007	manager@bodymindcentre.com	TRUE

Wanted Result with added Partner Emails column:

Partner ID	Email	Enabled	Partner Emails
PCA00000054	andrea@syoga.com	TRUE	andrea@syoga.com
PCA00000063	ahurlburt@fitness.com	TRUE	ahurlburt@fitness.com
PCA00000063	nkeane@fitness.com	FALSE	ahurlburt@fitness.com
PCA0000007	teginpopowich@hotmail.com	TRUE	teginpopowich@hotmail.com & manager@bodymindcentre.com
PCA0000007	manager@bodymindcentre.com	TRUE	teginpopowich@hotmail.com & manager@bodymindcentre.com

[Anonymous]

@AlB - this solved it!! My data is text and "TRUE" worked great - thanks so much

[AlB · Accepted solution]

Hi @Anonymous 

CALCULATE (
    CONCATENATEX ( t_b2b_na_partner_user, t_b2b_na_partner_user[EMAIL], "; " ),
    ALLEXCEPT ( t_b2b_na_partner_user, t_b2b_na_partner_user[PARTNER_ID] ),
    t_b2b_na_partner_user[enabled] = "TRUE"
)

where it's assumed that [enabled] is if type text. If it's boolean use  = TRUE( ) for the comparison

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers