Forum Discussion
Pulling field in another table connected via an inactive relationship
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?
2 Replies
FreemanZSuper User
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).
