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,
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 more
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.