Pulling field in another table connected via an inactive relationship

[mkjit256-outloo]

Hello

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?

[FreemanZ]

hi @mkjit256-outloo 

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

[mkjit256-outloo]

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).