Filter the other table based on the selected value

[Anonymous]

Hi,

I have a table called Employee Details with different Data Fields such as employee Id, Name, Department and Grade Rank.  I have created another duplicate table called Succesor Table. Now I want to filter the successor table automatically based on the selection (The selection is drillthroughed from the othe page) from the first table with the followning three conditons:

1. The successor must be from the same department

2. If the Grade rank of the current employee is n, then the successor grade rank must be either n, n-1 or n-2.

3. The selected employee should not be appeared in the successor table.

I was able to achieve the first condition by creating the relationship between the departments of the two tables and then using a forced selection in the Chiclet Slicer. But I coudnt achieve the other two conditions.

Any help on this is highly appreciated.

Thanks in Advance!

[vanessafvg]

can you provide sample data in text form or share your pbix.  please also give an example of what you expect.

[Anonymous]

Hi @vanessafvg,

Sure...,

Let us the above are the details of the selected emloyee

And this is the succesor table(Same as Employee Details Table). Now Based on the Selected employee, the result of the successor table should be as follows:

Hope, this clarifies my situation!

[vanessafvg]

need the data in text format so i can copy and paste, not a screenshot.  

[Anonymous]

Please find the data in the text format as requested

Employee Cde	Employee Name	Department	Grade Rank
1	A	Support Staff	1
2	B	Tech Team	4
3	C	Admin	4
4	D	Tech Team	2
5	E	Admin	3
6	F	Mngt	2
7	G	Mngt	2
8	H	Tech Team	2
9	I	Mngt	3
10	J	Support Staff	2
11	K	Tech Team	3
12	L	Admin	4
13	M	Support Staff	1
14	N	Support Staff	1
15	O	Support Staff	3
16	P	Admin	3
17	Q	Mngt	3
18	R	Admin	1
19	S	Tech Team	1
20	T	Admin	2
21	U	Mngt	4
22	V	Admin	4
23	W	Admin	3
24	X	Admin	1
25	Y	Tech Team	1