Forum Discussion

dshah12's avatar
dshah12
Helper II
3 years ago
Solved

Regarding data modeling

 

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 byApproved byitem
abcxyz2
xyzabc3

 

 

 

Employeemanager
abcbgh
xyzuij
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

3 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    3 years ago

    dshah12  Create a unique values of managers in another table and create to one to many to get the result

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

     

    • dshah12's avatar
      dshah12
      Helper II
      3 years ago

      Thanks a lot 
      I wanted it to work out for all visuals on page as well as the cards 
      How can I do that