Forum Discussion

fullstrum's avatar
fullstrum
Frequent Visitor
5 years ago
Solved

Filtering both Parent and Child

Hello,   I have the following data structure: Parent Table ParentID 111 222   Child Table ChildID ParentID 5 111 6 222   Tag Table Tag ChildID ParentID ...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    Hi fullstrum ,

    Try to adjust the relationship  from the below  to the picture 3:

     

     

    Don't forget to give thumbs up and accept this as a solution if it helped you!!!
    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

fullstrum's avatar
fullstrum
Frequent Visitor
5 years ago

It KINDA worked. In the matrix, it will show the correct parent/child... But if the parent had a child that did NOT have that tag, it'll show an empty row.

 

Also, having this relationship breaks a number of other reports. Which if I could get it to work right, would not be an issue (I'd create a different file to handle just this one case). All that to say, if there is a better solution out there, or a way to switch which relationship is being used for different filters, I'd love to hear it.