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.
See image.
I have a DAX function which creates a mailto string:
MailTo = "mailto://"&CONCATENATEX(ALLSELECTED(Blad1),Blad1[Column1],"; ")
So all values from Blad1[Column1] are shown in the string. Now i want to filter the mail adresses i selected. How can I do that?
Solved! Go to Solution.
Hi @DionTN ,
I think you can try this measure to achieve your goal.
MailTo =
"mailto://"
& IF (
ISFILTERED ( Blad1[Column1] ),
CONCATENATEX ( ALLSELECTED ( Blad1 ), Blad1[Column1], "; " ),
BLANK ()
)
Result is as below.
By Default:
Isfiltered:
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.
Hi @DionTN ,
I think you can try this measure to achieve your goal.
MailTo =
"mailto://"
& IF (
ISFILTERED ( Blad1[Column1] ),
CONCATENATEX ( ALLSELECTED ( Blad1 ), Blad1[Column1], "; " ),
BLANK ()
)
Result is as below.
By Default:
Isfiltered:
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.
mailto: does not use the "//" string.
It is not clear what issue you are trying to solve. Can you explain a bit more? What have you tried and where are you stuck?
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |