Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Bridging Table - Relationships

Hi guys.   This is more a database-related question, but it is PBI related anyway.   I have two FACT (FACT 1, FACT 2) tables and two DIM (DIM 1, DIM 2) tables. Both have different sales data. I n...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Just to close this thread, I used a 1 to many relationship with both ways, it works.

     

    I just had to be careful for the cases where there were 1 ID1 for many ID2, so that I could get something like an average value I used a measure like this:

     

    COUNT IDS =
COUNTROWS (
    FILTER (
        ALL ( 'Bridging Table' );
        'Bridging Table'[ID1] = MIN ( 'Bridging Table'[ID1] )
    )
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

For me it works like I was expecting, only from left to right.

 

I guess I'll have to live with that.

 

I'll just wait a day or so to see if someone finds an alternative, otherwise I will mark your reply as solution!

 

Thanks a lot!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Just to close this thread, I used a 1 to many relationship with both ways, it works.

 

I just had to be careful for the cases where there were 1 ID1 for many ID2, so that I could get something like an average value I used a measure like this:

 

COUNT IDS =
COUNTROWS (
    FILTER (
        ALL ( 'Bridging Table' );
        'Bridging Table'[ID1] = MIN ( 'Bridging Table'[ID1] )
    )
)