The second iteration of the tabular model for analysis services now allows us to implement very sophisticated security scenarios including row-level dynamic security.
In order to implement it, first we need the means of finding out the windows credentials of the user. That can be accomplished using the DAX function USERNAME(). Second, we need to map windows credentials with the desired functionality we are trying to secure. Third, we need the means to dynamically lookup that security logic in our map. That can be done using the DAX function LOOKUPVALUE().
Please follow this link for additional information.
business intelligist 