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...
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.

     

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