Page Filter Conditional Multiple Category Selection

Thanks for Sergii24's concern about this issue.

 

Hi, NMOORE 

I am glad to help you.

 

Yes, you can create a reference table, but you don't need to create a relationship between them.

Since you did not give me some test data for testing, I assumed some test data myself:

 

Then create a reference table:

 

Reference Table = SELECTCOLUMNS(Table1,"Category",Table1[Category])

 

Remember, do not create relationships between them:

 

Then create a Measure:

 

SelectedFilter = 
VAR _selectedValue = SELECTEDVALUE('Reference Table'[Category])
RETURN
IF(
    NOT ISFILTERED('Reference Table'[Category]),
    1,
    SWITCH(
        TRUE(),
        _selectedValue = "Within 25 Mile Radius" && MAX(Table1[Category]) = "Within 25 Mile Radius", 1,
        _selectedValue = "Within 40 Mile Radius" && MAX(Table1[Category]) IN {"Within 25 Mile Radius", "Within 40 Mile Radius"}, 1,
        _selectedValue = "Outside 40 Mile Radius" && MAX(Table1[Category]) = "Outside 40 Mile Radius", 1,
        _selectedValue = "No Postcode Available" && MAX(Table1[Category]) = "No Postcode Available", 1,
        0
    )
)

 

Drag the Category field of the Reference Table to the Slicer:

 

Then drag the Measure to the Filters panel and set it to 1:

 

Result:

 

I have attached the pbix file for this simple example below, I hope it helps.

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.