Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I am trying to filter a table that lets me filter on a field but show all the records related to another field. In the example below where all the data comes from one table. I would like to be able to filter on a MANAGER but show all the EMPLOYEE records in which the MANAGER filter was part of. In the example below, right now if I setup regular Manager filter and filter by PICARD I will be returned two rows. What I want to happen is when I select PICARD I want to show all the records of the EMPLOYEE in which PICARD was at least one of. So, in the below example, if I filtered for PICARD I want to see all records for SMITH and KIRK. If I selecte RYKER I would be returned all records for all three employees. Can anyone help?
Thanks!
Employee | Client | Manager | Hours |
Smith | A | Picard | 2.00 |
B | Ryker | 23.00 | |
C | Data | 5.00 | |
D | Sundance | 6.00 | |
E | Seven of Nine | 7.50 | |
Jones | F | Janeway | 6.90 |
G | Gorn | 6.30 | |
H | Ryker | 5.70 | |
I | Tuvok | 5.10 | |
J | Data | 4.50 | |
Kirk | K | Worf | 3.90 |
L | Picard | 3.30 | |
M | Ryker | 2.70 | |
N | Janeway | 2.10 | |
O | Spock | 1.50 |
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |