Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter one variable but not another

Hi there,

 

I would like to filter a table by a specific variable (Project Name) to return a list of people working on that project. However, I would like to still see which other projects the people within that list are working on and how their demand is spread across these other projects. 

In summary I want to filter Person by Activity by show ALL activities of those people and their spread of demand.

 

I have tried this measure: 

RH Demand % Filter =
VAR selectedvalue = SELECTEDVALUE('Capacity Forecast'[Activity/Project Name])
RETURN
CALCULATE(SUM('Capacity Forecast'[Demand %]), ALL('Activity Group'[Activity/Project Name]))
 
However, it is still only returning the demand % of the project selected.
 
Can someone please help?
Need Help

9 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Here is some very high level sample data with the main columns involved:

      Full NameActivity Demand (% of Available Time in Month)
      Person AProject 1 50
      Person AProject 3 40
      Person AProject 2 20
      Person BProject 2 50
      Person BProject 3 50
      Person CProject 4 40
      Person CProject 2 30
      Person CProject 1 10
      Person DProject 5 100

       

      Here is what I would like to see if I select Project 1 from a slicer (an example table made in excel which is meant to mimic a matrix in Power BI):

      Full Name Sum of Demand %
      Person A110
      Project 150
      Project 220
      Project 340
      Person C80
      Project 110
      Project 230
      Project 440

       

      Here is what I am currently getting:

      Full Name Sum of Demand %
      Person A50
      Person C10

       

      I would like the user to be able to filter by a certain project and get a list of names of all the people currently with demand on that project but also see their spread of demand on other projects they are working on.

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        Projects is a disconnected table defined as 

         

        Projects = VALUES('Table'[Activity])
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi there,

       

      When I select Project 1 it still only filters to the data relating to Project 1, it does not show me all of the other projects those people are working in:

      I would like to be able to get the list of people working on Project 1 but also see all of their other activities.