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?
Adjusting use relationship formula to include specific measure values on line graph
I have 2 rolling 14 day average calculations and Im hoping to display them (highlighted) on the same line graph: However I've tried to create a userelationship measure to get them on to the correct axis and I'm getting the correct numbers for Epi Count but Event count values are coming in as counts rather than the ones I need (highlighted on left below): I'm using this measure: Cumulative Rate - Event Count = CALCULATE(COUNTX('Sheet1',[Prev 14 Day Event Count]/4761865*100000),USERELATIONSHIP(Sheet1[Event Date],DimDate[Dates]),NOT(ISBLANK('DimDate'[Dates]))) Can anyone help get the Cumulative rate -Event counts on to the line graph SEE FILE ATTACHED https://www.dropbox.com/s/ksi9fm0kbzpj1hg/Notification%20vs.%20Epi.pbix?dl=0
Get Values from table using userrelationship and filters
Hi, I have two tables with an inactive many to many relationship and no active relationships. I'll call them table A and table B. Both tables have a different number of rows. I'm trying to bring a dates column from table A into a calculated column in table B. I'm doing a row level search on table A to find the match for the new calculated column in table B by using certain filter. My current function in table B now looks like this - = calculate(count(tableA[column 1]), Filter(tableA, tableA[date1] < tableB[date2] && .........&& tableB[date2] > tableA[date2]), USERELATIONSHIP(tableA[Apple], tableB[Apple])) the above function works perfectly and returns the count. However, I need the value in tableA[Column 1] to be returned using the filter in the above function and only if the above function returns 1 and then blank if it returns anything but 1. I am not sure how to modify the above written function to return the value which would be ideal while keeping all criteria of the above function. Also, if I am referencing the above function in any other column in tableB, then I get a circular dependency error or a variable error. Please help.
