Crossfilter and Interactions problem I cant solve.

[mgrayTCB]

This has been driving me crazy. Any help would be much appreciated.

The table on the left is filtered by the relative date slicer. Interactions between the date slicer and the table on the right are turned off. I always want the table on the right to show the dates and fees of the project selected in the table on the left. Only I want to be able to add the date to the table on the left without cross filtering the table on the right by anything other than project.

This is the result I am trying to get to with one change that I can’t make work.

This is what happens when I add date (which I need) to the table on the left. I have tried writing measures that are for all net fees but then I get the same value on every line and all the dates in the date table. I want the table on the right to be restricted to the selected project and only those dates where there is current or budgeted fees. How do I exclude the date from the cross filter when I select the row on the left?

[mgrayTCB]

Anyone else have any thoughts for a workaround?

[mgrayTCB]

That solves the crossfilter problem for the table on the right but now I dont get all the dates and amounts within the slicer range on the left. There has gotta be a way to do this.

[AlexisOlson]

I was afraid you might run into something like that.

You could concatenate dates together like I suggested here but that's not likely an ideal solution either.

I can't think of any other solutions or workarounds at the moment.

[AlexisOlson]

In general, I don't know that you can pick and choose which columns you want to be included in the cross filter.

In this case though, you might be able to get this to work if you change the Date column in the left table to be a measure like MAX ( Table1[Date] ) rather than using the date column as a dimension. If the date is no longer a dimension, then there isn't any date filter context from the left table to filter the right table with.