USERELATIONSHIP with a Table visualisation

[NZCraig]

Hi,

I have seen a few questions regarding USERELATIONSHIP and tables but not sure they quite answer what I am looking for. I have a measure that uses an inactive relationship between my date and fact table to get a count of orders due by week displayed in a stacked column chart.

I would like the use this chart to dynamically filter a table visualisation to show the corresponding order numbers and descriptions, however the table displays the orders using the active relationship, and so displays the wrong order numbers, as the active relations between the date and fact table is a different date range.

I can get the table to work by adding the measure as a column, but is it possible to do so without needing to add the extra column?

Many thanks in advance.

[mahoneypat · Accepted solution]

You would need to use a measure in the to-be-filtered visual that also uses USERELATIONSHIP to get that behavior (either in the visual or in a measure used to filter that visual).

Pat

[Nestum]

After searching for a while, I found this thread and this solution worked perfectly. Thank you.

[NZCraig]

Thanks @mahoneypat ,

Not sure if this is just a quirky thing or not, but by adding +0 to the end of my measure the table now seems to work as required without adding the column. However thanks for confirming that I might need to add the column if I still get get errors occuring.

Craig