help

Hi davidibi4524 

If your forecast lookup table looks like this:

You can create a measure to display the value based on which database is selected in a slicer.

Display Value = 
SWITCH (
    SELECTEDVALUE ( DATABASE[database] ),
    "MTR", SELECTEDVALUE ( 'forecast lookup'[MTR value] ),
    "MEX", SELECTEDVALUE ( 'forecast lookup'[MEX value] )
)

If your forecast lookup table looks like grouped forecast table which has a column for database name and another column for corresponding value, you can create a relationship between DATABASE table and forecast lookup table on database columns. Then the database slicer is able to filter it according to the selected database.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.