topic Re: Delete rows based on filter in DAX Commands and Tips

Delete rows based on filter

DionTN — Sat, 22 Oct 2022 07:11:22 GMT

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?

lbendlin — Sun, 23 Oct 2022 23:48:26 GMT

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 — Mon, 24 Oct 2022 09:55:11 GMT

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.