Dynamic Header with All data and by what is being filter

Hi Bmejia ,

Both Page level filter and drop down slicer are all filters, so if you use same Category column from table in them, it is hard to achieve your goal.

I suggest you to create an unrelated Category table for slicer.

Category for User = VALUES('Table'[Category])

Create a measure to filter this slicer.

Measure Filter = 
IF(MAX('Category for User'[Category]) in VALUES('Table'[Category]),1,0)

Add measure into visual level filter and set it to show items when value = 1.

New Measure:

Category Header = 
VAR _FilterbyPagelevel =
    CONCATENATEX ( VALUES ( 'Table'[Category] ), 'Table'[Category], ", " )
VAR _FilterbyUser =
    CONCATENATEX (
        VALUES ( 'Category for User'[Category] ),
        'Category for User'[Category],
        ", "
    )
RETURN
    "All Categories Being Filter at page level" & " " & _FilterbyPagelevel & " "
        & IF (
            ISFILTERED ( 'Category for User'[Category] ),
            "Data, Filter by" & " " & _FilterbyUser
        )

Result is as below.

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.