Forum Discussion

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

Measure returning value from a connected table ignoring other 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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for the reply from lbendlin , please allow me to provide another insight: 

Hi  Raj12 ,

Do you want to display the data that table LFSLTRNR shows as null values in measure.

You can click to show items with no data.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Hi, Thank you for your response. Measure is not working for the agent where there is no sale eg. for PAG:

This is the issue that I was facing where agent target is not showing when there is no sale in a month for an agent. Please help on this. Thanks