Forum Discussion
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 corresponding value from STORE[name]?
Kind regards
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
4 Replies
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)
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
