Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Filter Child back to Parent(s) without using bidirectional?

What is the "easiest" way to enable filtering on the child record so that selecting a child record will filter the parent(s)? In this scenario, not all parent records have children.   I have a ...
Need Help
  • bcdobbs's avatar
    bcdobbs
    4 years ago

    Just realised your need to show parents without children. Will see if I can modify.

  • bcdobbs's avatar
    bcdobbs
    4 years ago

    Think this works:

     

    PaymentMethodFilter = 
IF (ISFILTERED ( PaymentMethod ),
    INT ( NOT ( ISEMPTY ( PaymentMethod ) ) ),
    1
)

     

     

     

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

If you create a measure like

ParentFilter = INT ( NOT ( ISEMPTY ( 'Customer Payment Methods' ) ) )

and put it on the visual level filter of a parent visual (or slicer) with it set to "Is 1" you should get the desired interaction.

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

Just realised your need to show parents without children. Will see if I can modify.

  • bcdobbs's avatar
    bcdobbs
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Think this works:

     

    PaymentMethodFilter = 
IF (ISFILTERED ( PaymentMethod ),
    INT ( NOT ( ISEMPTY ( PaymentMethod ) ) ),
    1
)