Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
How can I create a view that allows me to select an employee in table1 and then it shows me the list of available managers in table 2?
For example: Here's the employee's table
Employee Name | Level | Group | Group1 | Level1 | Location | Friend | |
ABC1 | L1 | G1 | H1 | M1 | Loc1 | ABC7 | |
ABC2 | L2 | G2 | H2 | M2 | Loc2 | ABC6 | |
ABC3 | L3 | G3 | H3 | M3 | Loc3 | ABC5 | |
ABC4 | L4 | G4 | H4 | M4 | Loc4 | ABC4 | |
ABC5 | L5 | G5 | H5 | M5 | Loc5 | ABC3 | |
ABC6 | L6 | G6 | H6 | M6 | Loc6 | ABC2 | |
ABC7 | L7 | G7 | H7 | M7 | Loc7 | ABC1 |
Now when I click on ABC2 row, it should filter the manager table based on following criteria: -
1. Managers "Level" should be greater than the selected employee
2. The "Location" should be the same as of the selected employee
3. Same "Group" but different "Group1"
4. The Manager should not be employee's "Friend"
Here's the managers table that should get filtered based on selection above:
Manager Name | Level | Group | Group1 | Level1 | Location | Pending meets | |
ABC1 | L1 | G1 | H1 | M1 | Loc1 | ||
ABC2 | L2 | G2 | H2 | M2 | Loc2 | ||
ABC3 | L3 | G3 | H3 | M3 | Loc3 | ||
ABC4 | L4 | G4 | H4 | M4 | Loc4 | ||
ABC5 | L5 | G5 | H5 | M5 | Loc5 | ||
ABC6 | L6 | G6 | H6 | M6 | Loc6 | ||
ABC7 | L7 | G7 | H7 | M7 | Loc7 |
Any suggestion how this can be implemented or any workaround?
Hi, @Anonymous
Could you please tell me whether your problem has been solved?
You can try to create a measure as below:
Measure =
var _level=CALCULATE(MAX('Table'[Level]),FILTER('Table','Table'[Employee Name]=SELECTEDVALUE('Table'[Employee Name])))
var _location=CALCULATE(MAX('Table'[Location]),FILTER('Table','Table'[Employee Name]=SELECTEDVALUE('Table'[Employee Name])))
var _group=CALCULATE(MAX('Table'[Group]),FILTER('Table','Table'[Employee Name]=SELECTEDVALUE('Table'[Employee Name])))
var _group1=CALCULATE(MAX('Table'[Group1]),FILTER('Table','Table'[Employee Name]=SELECTEDVALUE('Table'[Employee Name])))
var _friend=CALCULATE(MAX('Table'[Friend]),FILTER('Table','Table'[Employee Name]=SELECTEDVALUE('Table'[Employee Name])))
Return
CALCULATE(MAX('Table (2)'[Manager Name]),FILTER(ALL('Table (2)'),'Table (2)'[Level]>_level&&'Table (2)'[Location]=_location&&'Table (2)'[Group]=_group&&'Table (2)'[Group1]<>_group1&&'Table (2)'[Manager Name]<>_friend))
If it doesn’t meet you requirement ,do you mind create a sample pbix file and list the expected result clearly, so that we can post detailed solution.
Best Regards,
Community Support Team _ Eason
anyone?
Hi, @Anonymous
Sorry,not very clear.
The employee's table you provided and the filtered manage table confused me.
They appear to be the same table. If possible, please explain it in more detail with specific examples.
Best Regards,
Community Support Team _ Eason
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |