Orderby expression returning invalid slice data

I am referencing a Project table and limiting the data to return projects that only match the user email.
No problem with the slice.

The issue is when I attempt to order the drop down results alphabetically. The expression returns project IDs that don’t belong to the email I am using.

My order by formula is ORDERBY(Projects[Project ID],[Project Name],FALSE).

When I remove the orderby expression, the drop down list displays a list I expect but not on alphabetical order.

What am I missing?!
Screen Shot 2021-08-06 at 5.40.27 PM|690x354

Because you’re using the base Table “Projects” in your expression, instead of the Slice “Project Slice Email”.

3 Likes