Filtering one field, but showing all values of other field

[westh121]

I have a data set with the fields Employee, Address, Step and (measure) # days.

The employee rents out homes and has to do this as fast as possible. The process consists of 3 process steps.

The employee is responsible for a number of addresses, lets say Address 1 and 4.

The first table below is the total set of data (not filtered).

In the second table a filter has been applied to employee Peter. The result consists of Address 1 and 4, but because he only did steps 1 and 3, step 2 is gone also.

The third table is what the user wants to see when filtered on Employee Peter. They want to see Address 1 and 4 (like in table 2), but they don’t want the steps to be filtered based on employee Peter, because he is responsible for all steps in the process (although somebody else did these process steps).

How can I accomplish this in Power BI?

1.Total set of data
	Step 1	step 2	step 3
Address 1	20	10	12
Address 2	15	8	10
Address 3	6	14	12
Address 4	10	12	12
Address 5	12	8	20
2.Filter on Employee Peter
	Step 1	step 3
Address 1	20	12
Address 4	10	12
3.Required
	Step 1	step 2	step 3
Address 1	20	10	12
Address 4	10	12	12

[sturlaws]

Hi @westh121 

by your description, your data set would also contain a column with the person who performed the step. How do you determine if an employee is responsible for an adress? 

Cheers,
Sturla

[westh121]

Hi Sturla,

You are right, the dataset contains a column with the person who performed the step. It actually looks like this (in my first post I presented it as a matrix).

Address	Step	Employee	# days
Address 1	step 1	Peter	20
Address 1	step 2	John	10
Address 1	step 3	Peter	12
Address 2	step 1	John	15
Address 2	step 2	John	8
Address 2	step 3	Alice	10
Address 3 ….
Address 4	step 1	Peter	10
Address 4	step 2	Alice	12
Address 4	step 3	Peter	12
Address 5 ….

[sturlaws]

I think the easiest solution would be to create a new table with employee and the addresses that employee is responsible for,

Employee	Address
Peter	Address 1
Peter	Address 4
Alice	Address 2
John	Address 3

and create a relationship with the main table on Address, and set your slicer/filter to filter on employee from this new table

[westh121]

Thanks for your reply.

I dont't think it is possible to add a table, because I have a connection to a SSAS tabluar model.