Delete rows based on filter

[DionTN]

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?

[Anonymous · Accepted 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.

[lbendlin]

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?