Forum Discussion

dokat's avatar
dokat
Post Prodigy
4 years ago
Solved

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 ...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    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?

     

dokat's avatar
dokat
Post Prodigy
4 years ago

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.

 

 

jdbuchanan71's avatar
jdbuchanan71
Super User
4 years ago

Odd, in your manange relationships screen shot the relationship is active but in your first one it is not (the dotted line).

 

  • dokat's avatar
    dokat
    Post Prodigy
    4 years ago

    jdbuchanan71 It was deselected, after i put a checkmark i think thats when it became active.

     

     

  • dokat's avatar
    dokat
    Post Prodigy
    4 years ago

    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.