Forum Discussion
Solved
Slicer Value from different table
I have two tables, one listing each investigator individually, and their years of experience. The second table lists each research team, and the status of the investigator on that team (active or ina...
Hi katemke ,
Please create a measure as below to get the average year of experience of active investigators on team:
Average year of experience = VAR _selTeam = ALLSELECTED ( 'Table 2'[Team Name] ) RETURN CALCULATE ( AVERAGE ( 'Table 1'[Years of Experience] ), FILTER ( 'Table 2', 'Table 2'[Team Name] IN _selTeam && 'Table 2'[Status on Team] = "Active" ) )If the above one is not what you want, please provide your expected result and explain the details with examples. Thank you.
Best Regards
Rena
Hi katemke ,
Please create a measure as below to get the average year of experience of active investigators on team:
Average year of experience =
VAR _selTeam =
ALLSELECTED ( 'Table 2'[Team Name] )
RETURN
CALCULATE (
AVERAGE ( 'Table 1'[Years of Experience] ),
FILTER (
'Table 2',
'Table 2'[Team Name] IN _selTeam
&& 'Table 2'[Status on Team] = "Active"
)
)If the above one is not what you want, please provide your expected result and explain the details with examples. Thank you.
Best Regards
Rena