Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Pulling field in another table connected via an inactive relationship


I have the three table below:


that are related as follows: 

(1)-> *: Active Directory User[User],  Workspace_All_RAW[user] 

(1)-> *: Active Directory User[User], Datasets[ConfigureBy], Inactive

(1)-> *: Dataset[DatasetID], Workspace_All_Raw[DatasetID]


In my report, i am creating a slicer based on Active Directory User[User]. I am trying to pull the Name of workspace from Workspace_All_Raw table (working good) and the Dataset Name from the DataSets table using a measure: 

Measure = CALCULATE(SELECTEDVALUE(DataSets[Name]),USERELATIONSHIP(DataSets[ConfiguredBy],'Active Directory Users'[Users]))


but my measure is showing nothing when placed in a table visual.

1- How can i get the datasets name?

2- Is it possible to redesign my model in a different way to avoid having this inactive relationship?


Community Champion
Community Champion

hi @mkjit256-outloo 

from what mentioned above, the third relationship - Dataset[DatasetID], Workspace_All_Raw[DatasetID] - seems unnecessary. Or?

Thanks for your reply.

In my question i have only included these three tables, but my model is more complicated that what you see, and i need the third relationship between ,  - Dataset[DatasetID], Workspace_All_Raw[DatasetID] . What i am looking to do is to select a user from the active directory table and get the workspaces name that he is in (from Workspace_All_Raw table) and the dataset id that they have configured (from the Datasets table).

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors