Forum Discussion
Filter one variable but not another
set the measure as a filter for that visual
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-p/963216
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
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.
Projects is a disconnected table defined as
Projects = VALUES('Table'[Activity])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
set the measure as a filter for that visual