SLICE or SECURITY FILTER to last 50 Entries Only

[Tony_Insua]

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!

[LeventK · Accepted solution]

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

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

OR

[_RowNumber]<=50

[Rifad]

I don’t think the above expression works @LeventK