Forum Discussion

katemke's avatar
katemke
Frequent Visitor
6 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

katemke - One possible way would be to filter your visual by "Active". You might need to do something along the lines of a complex selector. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534


Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.