Current User - MY STUFF.

I've managed to sort out a fairly straightforward approach.

I love it when a plan comes together.....

Set up a ‘mapping table’ to include the email address of the user plus an ‘interest’ column or the ‘thing’ that you want to slice/filter….

You can select single values or multiple values if concatenated with a pipe.

Create a DAX table which becomes the slicer value. It’s a UNION of the distinct values of the column of interest (in this case it's the [team] column from my Data table) and a ’My Stuff’ entry.

In this example my raw data has a Team column and the mapping table maps individuals to teams ‘of interest’

InterestsUnion = UNION(DISTINCT(SELECTCOLUMNS(Data,"interest",Data[team])),{"My Stuff"})

Now you can create a DAX expression which returns a single text value which is a concatenated string containing all the selected values from the slicer.

Return either the selected value(s) OR the interest value from the mapping table.

InterestList = var SelectedValues = CONCATENATEX(Values('InterestsUnion'[interest]),'InterestsUnion'[interest],"|")

var PersonSpecific = LOOKUPVALUE(Map[interest],Map[person],USERPRINCIPALNAME())

return

if(SelectedValues = "My Stuff",PersonSpecific,

    SelectedValues)

Now you can create a DAX [check] measure so you can determine whether to show the row or not.

As the LIST is a concatenated string with a pipe| separator we can use PATHCONTAINS expression. If no slicer value is selected show all rows.

Check = if(PATHCONTAINS([InterestList],min(Data[team])),1,

    if(isblank([InterestList]),1,0)

)

Set a filter on the visual of choice to show records where [check] = 1.

In the example below I am logged on and my 'Teams' of interest are Team A and B.

The dataset contains Team A B and C only.