Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Current Data:
Partner_ID | 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 | 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 |
Solved! Go to Solution.
Hi @AnetShe
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
@AlB - this solved it!! My data is text and "TRUE" worked great - thanks so much
Hi @AnetShe
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
78 | |
69 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |