Filter one variable but not another

Anonymous

Not applicable

3 years ago

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.

Forum Discussion

Related content

Variable still filtered in visual where using REMOVEFILTERS

Slicer Filtering Another slicer

Filter depending on another filter

Passing a variable from one pipeline to another

Creating a dynamic filtered table variable