Forum Discussion

DionTN's avatar
DionTN
Helper II
3 years ago
Solved

Delete rows based on filter

 

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?

 

Filter
Help
string
Tutorial
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.