Forum Discussion
Solved
Multiple Role-Playing Dimension and RLS
Hi, I've browsed around existing questions for a while but so far haven't seen my issue, and ChatGPT is giving me the runaround so far, so figured I would post my question. It has to do with the...
Hi, jmunn
Based on the image you showed at the end, I've created a simple data set:
My relationship is as follows:
I created an RLS role as follows:
FACT Table DAX:
VAR _user_location = MAXX(FILTER('UserInfo','UserInfo'[Email] = USERPRINCIPALNAME()),'UserInfo'[Location]) VAR _table = SELECTCOLUMNS(CALCULATETABLE('REF',FILTER('REF','REF'[Location] = _user_location)),'REF'[DepartmentArrivalCombination]) RETURN 'FACT'[DepartmentArrivalConcatenated] IN _tableBe able to get the results you expect:
I've uploaded the PBIX file I used this time below.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you lbendlin for this.
I'm trying to figure out how that would work:
In this approach, it seems that for each location, the Combinations table needs to include a record for every combination in which that location is involved, departure and/or arrival.
Is this what you had in mind?
Please provide sample data that fully covers your issue.