Forum Discussion

Nielf's avatar
Nielf
Helper I
2 years ago
Solved

Filter table visual on both active and inactive relationship

Hello,  I have a data model like the one below, where there are two relationships between the Account table and the opportunity table. Customer (parentaccountid) is the active relationship, and th...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Nielf 

     

    This is because when you drag columns from the Opportunity finance table into the table visual, it is still filtered by the default active relationship passed by the Account table and the Opportunity table. If you want to see results based on both relationships, you still need to create a similar measure to activate the inactive relationship to get corresponding results from the Opportunity finance table. Inactive relationships can only be used in measures. It cannot be passed in a visual invisibly. 

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

  • Nielf's avatar
    Nielf
    2 years ago

    Anonymous thanks for the swift help. That makes sense. 

Nielf's avatar
Nielf
Helper I
2 years ago

Anonymous 

It works partially for me. I have created another measure, which combines the value from the active and inactive relationship, which I can display in th table.

 

Combined sales price (base) = 

IF(ISBLANK([$ All opportunities]),
[End Customer Sales Price (Base)], [$ All opportunities])

 

 

While it works on row level in the table, the total is wrong, since only the active relationship seem to used there. Do you know if it's possible to work around this? Total should be 213.604.374.