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

[WillowMobileSys]

We need a little more context about what you are trying to accomplish.

Do you want to the app to have "PRIVATE" usage for each user?  This means no one can see anyone else's information - not even the App Creator.

OR

Do you want an app an where the App Creator, or possibly some Admin, sees all users data but each User only sees their own?

[Eunice4U]

Hi, I want an app that Admin & Manager role can see all users data, but other users can only see their own

[jaichith]

User Security Filter