Forum Discussion

DionTN's avatar
DionTN
Icon for Helper II rankHelper 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...
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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper 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?