Find value via a bridge table

[Dicko]

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 corresponding value from STORE[name]?

Kind regards

[Jihwan_Kim · Accepted solution]

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]

@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]

Hi Amit,

Could you please elaborate?

Thanks, Dicko

[Dicko]

Hi Amit,

Can you please explain?

(Indeed both relationships are 1-M.)

Kind regards, Dicko