Relationship issue

[ttaa4455]

Hi,

I'm running into a weird problem and not sure what's the issue. Currently I have my Main table, and sub table modelled to it called "Director_table" that has columns for "director name" and "region", "Reps_Table" has columns called "Reps name" and "Reps ID". 
I then have some measures that I made called sales current ytd and sales last ytd, and sales  current ytd # change. These where made from the "main table"

When and create a visual table and put the columns I mentioned above into the visual table and the sales current ytd and sales last ytd the table responds fine and is making connection of the sub table with the main table, but once I put the % chg measure it freakes out and can't make the connection. Why is that? But if I only use columns from the main table the % Chg measure does the correct thing. 

[Anonymous · Accepted solution]

Hi @ttaa4455 ,

Can you tell me what your measure formula is?

Is that the error happen when you put the measure into the visual?

You would provide the detailed error message by clicking the error in the visual.

Best Regards,

Stephen Tao

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