SLICE or SECURITY FILTER to last 50 Entries Only

Hi Community,
I have a table slice that displays all activities for all users of the app.
How can I set it so that the slice filters the TEAM MEMBERS only (each individual is part of a TEAM with a TEAMID (with a TEAM NAME)) AND also limit the entries to the last 50 entires only (for performance purposes)?

I know how to do a row filter like [TEAMID]=XXXXX; however, I’d like to set it so it’s automatic to the users team.

Would be great to do this on the security filter side as well to improve performance.
Thanks!

You can use the Security Filters OR Slice for that purpose i.e.

IN([Key],TOP(SELECT(TableName[Key],TRUE),50))

OR

[_RowNumber]<=50
1 Like