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.

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.