Forum Discussion
Selective crossfiltering between visuals
OneDrive has been locked by the administrator of my organization. I have used WeTransfer to share my file. I will also provide screenshots as WeTransfer will remain only temporary: WeTransfer Link for my PBI file
Nevertheless, the conclusion is that it seems to work with my way. However, god knows what trouble I am putting myself in with things I have not foreseen now. For example, time intelligence functions using one universal date dimension rather than two which I have now.
For now, I can crossfilter in both directions: Sales > Orders and Orders > Sales. Also, the date slicer works. The Orders and Sales table in this overview have different date dimension on their axis.
My model using the bridgetable looks like this. The inactive relationships are used for the DAX measure USERELATIONSHIP (see later screenshot how the particular measure looks like).
The bridgetable shows a unique combination of datekey and orderkey.
And here are my two sales and order measures.
Hope this helps and if anyone knows a simplier solution, please share!
Quick update:
If anyone knows a different way of sharing the desktop file. It could help other users and it is a pity Wetransfer only keeps the file for 7 days. Others are also very welcome to reshare my file who have better sharing capabilities.
I have tried the following dax formula:
Anonymous I know this is an old thread, but seconded. It's really difficult to achieve the kind of specific filter action options available in Tableau's actions menu.
And this is probably little help now, so far behind, but why not relate sales and orders with a bidirectional relationship on order ID? And then have a common date table with a single-direction filter to both the order and sales tables.
If you used the date field from the actual order and sales tables in your tables, those don't have a relationship to each other, so that should just filter on orderid. If you needed a common date, you could use the date table.