How to Filter Slicer by unrelated table?

[Anonymous]

I'm a bit stumped on my current problem.  I would like to filter the Status column in the Status table by the Users Language column. 
My users table must flow through the entity table. Status must also flow into entity.

Any help would be greatly appreciated!

[Anonymous · Accepted solution]

I ended up solving this problem by creating a measure that filtered the slicer for me.

The measure code looked like this 

 Status Language Filter =

var selectedLang = [Current Language] -- this gives the user's language

var userTableLangues = VALUES(Users[Language])

var flockStatusTables = VALUES('Translated Status'[Language Code])

return

IF(selectedLang IN StatusTables,"TRUE","FALSE")

Then,for the slicer on the visual, I used the advanced filter when that measure = 'TRUE' .

[MansRydell]

Thanks for sharing bud ✌️, solved my problem.

[PaulDBrown]

I'm not too sure your model is optimized. You havve a number of tables linked by many-to-many relationships which should be avoided. 
Can you share a PBIX file renaming confidential column names? Or dample data for tables in the model?