Forum Discussion

Raj12's avatar
Raj12
Icon for Helper III rankHelper III
2 years ago

Measure to return value from a connected table based on another table selection

Table 1 (LFSLTRNR) has monthly sales for an agent Table 2 (Agents Target) has monhtly target for an agent. Table 1 and 2 are connected via agent code   Report has Sale date filter from table1 and...
Need Help
Show and Tell
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

That would be a question for your data model. How does that look like?

Raj12's avatar
Raj12
Icon for Helper III rankHelper III
2 years ago

Hi Ibendlin,
Please find below data model:

Agent Code & Sales Code of two table are connected together.
Now if we select STRNDT Feb 2024, there is no sale for Agent PAG but there is target for him, hence want measure to show target even if there is no sale for an individual.
Please suggest on the same. Thank you

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Is that bidirectional *:* ?

    • Raj12's avatar
      Raj12
      Icon for Helper III rankHelper III
      2 years ago

      yes its bi-directional

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        that's the worst case scenario.  Correct it if possible or use CROSSJOIN(..,NONE) to temporarily disable the relationship.