Forum Discussion
Bridge Table Not Working
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?
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).
jdbuchanan71 Do you i need to create new relationship between Region and Bridge for each slicer?
For Ex: If i want to have Category slicer do i need to create a new relationship between two tables? Ithought because Bridge table links POS and Region table via Brand i didn't have to to create new relationship. Currently i am getting all incorrect measure results.