Forum Discussion

Dicko's avatar
Dicko
Helper II
5 years ago
Solved

Find value via a bridge table

Hi all,   I've got three tables: STORE store_id name   STORE_USER store_id user_id   USER user_id store_name   How can I fill USER[store_name] with the co...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Dicko 

    In the sample data model like below, I created the below calculated column.

    If you can share your sample pbix file's link, I can try to look into it to come up with a more accurate solution.

     

     

    StoreName CC =
    CALCULATE (
    MAXX ( StoreUser, RELATED ( Store[Name] ) ),
    CROSSFILTER ( User[UserID], StoreUser[UserID], BOTH )
    )

     

    https://www.dropbox.com/s/dwgj8et9ejf7q07/dicko.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

     

amitchandak's avatar
amitchandak
Super User
5 years ago

Dicko , if store to store user is 1-M and user to store user is 1-M

 

then use store[name], user[store_name] along with countrows(store_user)

Dicko's avatar
Dicko
Helper II
5 years ago

Hi Amit,

 

Can you please explain?

(Indeed both relationships are 1-M.)

 

Kind regards, Dicko