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.
Hi Anonymous ,
If the relations between two tables based on the Date, it will act like yours, but if relations based on another column such as order ID, it should work fine.
If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
BTW, pbix as attached.
Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more
Thank you for your reply and you effort to even share a PBI example file.
However I am still struggling getting this to work with other dimensions. The both way relationship between the facts cause ambiguity when adding other shared dimensions.
I am working on a bridge (factless) table to allow both side interactivity and with USERELATIONSHIP I am creating seperate measures. Apart I keep two seperate date dimensions so disable the axis to be filtered. Nevertheless, I feel like this is an extremely cumbersome way of achieving this and I also find it hard to foresee what other problems I am running into with this solution.
I find it hard to believe there is no more easier solution, such as Tableau "actions".
Thanks for your reply still!
Hi Anonymous,
It should still work fine in a single way relationship (order -> sales), it may be helpful for DAX if you give simple description of two tables such as mockup column names.
You can share your mockup file mentioned before if you don't have any Confidential Information inside by uploading your files to One Drive and share the link here.
Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it moreOneDrive 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.