Forum Discussion
Filter one variable but not another
set the measure as a filter for that visual
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
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