Disconnected Table DAX

Hi All,
Firstly  pbiuseruk  thank you for your solution!
And kapildua16 ,According to you, you want to create a single filter and then incorporate all the filters into this one filter, right?
Then we can create a new Table and put all the values we need to filter into this table, and then add it to the page filter.

FilterTable = 
UNION(
    SELECTCOLUMNS(DISTINCT('Table'[Region Name]), "Filter", 'Table'[Region Name]),
    SELECTCOLUMNS(DISTINCT('Table'[Country Name]), "Filter", 'Table'[Country Name]),
    ROW("Filter", "Global")
)

After that, we write a measure to determine if the choice is correct:

IsVisibleMeasure = 
VAR SelectedFilter = SELECTEDVALUE(FilterTable[Filter])
RETURN
    IF(
        SelectedFilter = "Global",
        1,
        IF(
            SELECTEDVALUE('Table'[Region Name]) = SelectedFilter ||
            SELECTEDVALUE('Table'[Country Name]) = SelectedFilter,
            1,
            0
        )
    )

If you have further questions you can check out my pbix file, I hope it helps and I would be honored if I could solve your problem!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.