Filter one variable but not another

[Anonymous]

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?

[Ashish_Mathur]

Hi,

Will this work?  You may download my PBI file from here.

Hope this helps.

[Anonymous]

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.

[Ashish_Mathur]

In my solution. i have used Filters (not slicers).

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.

[lbendlin]

This is a standard "filtering up" pattern.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Anonymous]

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

Full Name	Activity	Demand (% of Available Time in Month)
Person A	Project 1	50
Person A	Project 3	40
Person A	Project 2	20
Person B	Project 2	50
Person B	Project 3	50
Person C	Project 4	40
Person C	Project 2	30
Person C	Project 1	10
Person D	Project 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 A	110
Project 1	50
Project 2	20
Project 3	40
Person C	80
Project 1	10
Project 2	30
Project 4	40

Here is what I am currently getting:

Full Name	Sum of Demand %
Person A	50
Person C	10

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]

Projects is a disconnected table defined as 

Projects = VALUES('Table'[Activity])

[Anonymous]

Hi there,

Thank you this helps in that it flags the people working on the projects. Is there then a way I can take this measure a step further so that it filters to just the people with the flag?

Thanks

[lbendlin · Accepted solution]

set the measure as a filter for that visual