Forum Discussion
Bridge Table Not Working
- 4 years ago
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?
Can you share your .pbix file? (post it on drop box and share the link)
- dokat4 years agoPost Prodigy
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