Forum Discussion
Post ProdigyBridge 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
- jdbuchanan71
Super User
If you right click on the line and go to Properties you can make it active.
dokatjdbuchanan71 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.
- jdbuchanan71
Odd, in your manange relationships screen shot the relationship is active but in your first one it is not (the dotted line).
- jdbuchanan71
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?
- dokat
jdbuchanan71 Thank you for pointing me to right direction.
- jdbuchanan71
The relationship between Bridge and Region is inactive.
- dokat
jdbuchanan71 Thanks for your reply. How can you activate it?
- jdbuchanan71
Can you share your .pbix file? (post it on drop box and share the link)
- dokat
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
