Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to create relationship of employee with created by and approved by as they both have common manager name.
So basically I have filter of manager and in accordance to that I want to get data of total created by and approved by under specific manager
I right now have relationship of Many -Many between Approved By and employee
But when I am tracking for created by I am not getting accurate answers
Created by | Approved by | item |
abc | xyz | 2 |
xyz | abc | 3 |
Employee | manager |
abc | bgh |
xyz | uij |
Solved! Go to Solution.
Hi @dshah12 ,
I suggest you to inactive the relationship between [Employee] and [Created by]/[Approved by].
Measure:
Filter =
IF (
OR (
MAX ( Table1[Approved by] ) IN VALUES ( Table2[Employee] ),
MAX ( Table1[Created by] ) IN VALUES ( Table2[Employee] )
),
1,
0
)
Add this measure into visual level filter and set it to show items when value = 1.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @dshah12 ,
I suggest you to inactive the relationship between [Employee] and [Created by]/[Approved by].
Measure:
Filter =
IF (
OR (
MAX ( Table1[Approved by] ) IN VALUES ( Table2[Employee] ),
MAX ( Table1[Created by] ) IN VALUES ( Table2[Employee] )
),
1,
0
)
Add this measure into visual level filter and set it to show items when value = 1.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a lot
I wanted it to work out for all visuals on page as well as the cards
How can I do that
@dshah12 Create a unique values of managers in another table and create to one to many to get the result
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
96 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |