Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
mdex
Resolver I
Resolver I

Creating a list as a calculated column, then comparing 2 lists

I'm not even sure something like this is possible.

 

Imagine have 3 tables with the following columns.

 

Requests
ReqID, Customer, Requestor

Requestors 
Requestor

RequestorGroup
Requestor, GroupID

  

I can use simple relationship and RLS between Requests and Requestors to that Requestors can only see their own Request records.

 

What we also have is Requestor Group. This is a list of Requestors which for one reason or another are allowed to view each others requests. If you have the same GroupID as another person, you can see each others. Am I able to use some sort of lookup/List to create a relationship I can use with RLS? The challenge lies with the fact that requestors can be in multiple groups.

0 REPLIES 0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.