Help : DAX measure

Hi askme1217 ,

For this you need to use the syntax of the table/column and then using a sintax with a in statement. and for each table add an AND.

So you would get something similar to: 

url =   https://app.powerbi.com/xxxxxxxx?experience=power-bi ?filter=Table1/Column1 in ('data1', 'data2') and Table2/Column1 in ('data3', 'data4')

You can check the details on this link below:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#filter-on-multiple-fields
To get the values for the DAX syntax you would need use a concatanex of the VALUES of your field values that are selected on the slicer.

So that would be something similar to:

filter Values =
VAR slicer1 =
    CONCATENATEX (
        ADDCOLUMNS (
            VALUES ( 'Table1'[Column1] ),
            "FilterColumn",
                "'" & 'Table1'[Column1] & "'"
        ),
        [FilterColumn],
        ","
    )
VAR slicer2 =
    CONCATENATEX (
        ADDCOLUMNS (
            VALUES ( 'Table2'[Column1] ),
            "FilterColumn",
                "'" & 'Table2'[Column1] & "'"
        ),
        [FilterColumn],
        ","
    )
RETURN
    "https://app.powerbi.com/xxxxxxxx?experience=power-bi & ?filter= Table1/Column1 in (" & slicer1 & ") and Table2/Column2 in (" & slicer2 & ")"

Be carefull that this type of measure can return a error in text lenght. you may also need to adjust the full detail of the URL and the way the slicers works in the concatanex