How to assign the filter not exact match to manage role

[saranp780]

I have a list of user like this.

User	Cost
JVAS01	2000$
JVAS02	3500$
JVAS03	5500$
JVAS04	5000$
JVAS05	2000$
JVAS06	2500$
KVAS01	3200$
KVAS02	4400$
VVAS01	2900$
VVAS02	4000$
VVAS03	5500$

I want to set the filter to role management because I don't want to let people from other departments that I also share my report to see the cost at my department. My requirement is let the user see the only cost of their department such as "JVAS" can display only their cost disable to see "KA and VV" cost.

I have tried to put [User Name] = "JVAS"  but when I swap to view role nothing happens. How can I do?

My license is Power BI Pro.

[Anonymous · Accepted solution]

Right now your filter says that the entire cost code has to be "JVAS".  Instead you want to is only check the left 4 characters and see if they equal "JVAS"

https://docs.microsoft.com/en-us/dax/left-function-dax

Should be something like LEFT([YourColumn], 4) = "JVAS"