Dashboard - filter as per user setting, multiple results

[Eunice4U]

Hi everyone,

I hope there is some help in this forum for an issue I have struggled. I have searched wide for answers without luck.

I have a table "Goal" with security filter whereby only user can view his own data.

I created a filter table named "Filter Month" for the user to select Month, and have a slice "My Goal" in "Goal" table to show the results. It works fine when user1 & user2 select the filter month, the filter table didn't change & affect other user's selection.

Here's the problem I'm facing, when I have another table named "Total", to calculate total amount from "My Goal" slice, it didn't changed the results as per user setting, it only shows result based on the app creator (which is me)

SUM(SELECT(Goal[Completion %],AND(IN([Date],Filter Month[Month]),IN([Assignee],Filter Month[Assignee]))))

This is user2 view, the total didn't changed as per user:

This is app creator view, the "Total" table shows the result as app creator:

Would really appreciate your guidance.
Thanks