Forum Discussion
Bridge Table Not Working
Hi,
I have two data tables POS and Region with M:M relationship. I created bridge table so measures by both tables can be controlled by one slicer. However after creating bridge table and slicer i can only control POS table and not Region. Not sure what's causing this problem but appreciate any help
Thank you for sharing that. I made some measures to just SUM the Value column from POS and Region tables so I could look at the amounts.
_POS_Value = SUM ( 'POS'[Values] )_Region_Value = SUM ( 'Region'[Values] )I also made a measure to look at the difference between your two test measures.
Test Measure Variance = [Region Test Measure] - [POS Test Measure]Looking at a breakdown of the number by brand under the correction category the Bridge[Brand] 'Liquid Paper 2-in-1 Bottle' only has a total amount in the 'POS'[Values] column of 81k where the Region'[Values] column has 498k so that looks like most of your variance.
Most of the other amounts are very close.
Could it be a problem with data missing from the POS table?
15 Replies
If you right click on the line and go to Properties you can make it active.
jdbuchanan71 It gave me different option, i didnt see properties i clicked on manage relationships and put a check mark near region table. Now slicer selection returns values from Region table however they are not correct. Please see below.
Odd, in your manange relationships screen shot the relationship is active but in your first one it is not (the dotted line).
Thank you for sharing that. I made some measures to just SUM the Value column from POS and Region tables so I could look at the amounts.
_POS_Value = SUM ( 'POS'[Values] )_Region_Value = SUM ( 'Region'[Values] )I also made a measure to look at the difference between your two test measures.
Test Measure Variance = [Region Test Measure] - [POS Test Measure]Looking at a breakdown of the number by brand under the correction category the Bridge[Brand] 'Liquid Paper 2-in-1 Bottle' only has a total amount in the 'POS'[Values] column of 81k where the Region'[Values] column has 498k so that looks like most of your variance.
Most of the other amounts are very close.
Could it be a problem with data missing from the POS table?
jdbuchanan71 Thank you for pointing me to right direction.
The relationship between Bridge and Region is inactive.
jdbuchanan71 Thanks for your reply. How can you activate it?
Can you share your .pbix file? (post it on drop box and share the link)
jdbuchanan71 Yes, please see below link. Region and POS Test Measures should return same dollars in both tables. Please let me know if you have any questions.
https://www.dropbox.com/s/hzmrram3a38z3s3/Bridge%20Table%20Sample%20File.pbix?dl=0
