DimTable crossfilter problem

[Anonymous]

Hello, I m having a small issue. My dashboard needs to slice 2 tables with one filter. Linking distinct union to table "Tjob" and "Tscan" is blocked cause of crossfiltering option. My data only works if the crossfiltering is working.

Key relationship is "ID" to "RefID"

Ony Workaround the issue?

[Anonymous · Accepted solution]

There are 2 charts and 1 table.

First table is in 100% based on Tjob table data. % performance by product number.

Second Table is a performance by tester name.  Name of tester cames from Tscan. Both performances are based on dax from tjob data table.

Table is a mixed data from Tjob and Tscan. Based on unique ID reference. For id there are dates of entries (Tscan), product numbers, names, tester names etc.

Time slicer from Tscan returns on the chart empty entries outside of slicer scope( entries come from tjob, but reference ID didnt filter it properly). Dont know why but standarizing time dates in both data tables helped.

[vanessafvg]

can you explain what you are trying to achieve  Understanding the requirement is useful in order to step back from what you doing so one can come up with a solution.