Retail Store Sale & Closing Inventory Relation Management

[Anonymous]

Hi,

I am trying to link 2 tables Sales and Closing Inventory by Season-Gender-Category but its not working i have applied slicer but it sorts only Sale or Stock.

Regards,

Ammar

[jaideepnema]

I removed the unnecessary relationships and made the required relationships between the tables active .......

Appreciate a Kudos if this resolved your query !!

[jaideepnema · Accepted solution]

@Anonymous Change the relationships as shown below:

Hope that helps !! 

Please accept this as a soluion if this resolved your query !! Appreciate a Kudos also 😀

[Anonymous]

thankyou for the help but please share a little wisdom about what i was doing wrong because i am beginer.

[amitchandak]

@Anonymous , I am assuming these are the common dimensions

Season , Gender and Category and you are creating a star schema  -https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

https://www.seerinteractive.com/blog/join-many-many-power-bi/

[jaideepnema]

@Anonymous 

Upload your file on drop box or one drive and share the link 😀

[Anonymous]

here you go.

https://1drv.ms/u/s!AsZT5zMyLbENgSSf5OyX6m9DfNeR

[jaideepnema]

@Anonymous which two tables are you trying to join and basis which column ?

[Anonymous]

sale and CS tables

[Anonymous]

Okay what i want is link 3 fields season-gen-cat. on the slicer when i select ss-20 or men or tees. sale and inventory both show values according to selection, but at current it changes only stock units.

[jaideepnema]

Is this what you are looking for ?

[Anonymous]

yes how did you do it

[Anonymous]

yesss how did you do it??

[jaideepnema]

@Anonymous  can you share sample dataset or file for this ....as your issue is not clear 

[Anonymous]

@jaideepnema how can i share you please guide.