Beginner - Looking for a way to display and compare to value in dimensional table

[CeiBob]

Hello!

TLDR: I am looking for how to receive this result from the tables below.

When I select a location via a slicer, I want my card to show the QTY of models remaining. This is like stating value = Qty column value where model = 'amountdeployed'[Model]' yet I don't know how to set up that kind of query.

Fact Table: (amount deployed)

ID	Location	Model
A1	LA Office	M23571
A2	LA Office	M21621
B1	Seattle	A525
B2	Seattle	A525
C1	Chicago	M23571
C2	Chicago	M23571

Dimensional Table: (amount remaining)

Model	Qty
M23571	8
M21621	5
A525	1

The relationship setup for this data is unimportant to me so I don't mind changing it. The only important thing is that I can get the data I want when I need it. My current data has over 10k devices and qty's and I just want to have a quick glimpse into the available quantity for this model. Whenever I have tried to pull the Qty value, it refuses to see the information in that table, and perhaps a function that solves this is something I am having trouble finding. 

I have been playing with these exact tables here and trying measures. So far I have not found a solution which can relate this data.

Any help is appreciated. Thanks!

[Fowmy · Accepted solution]

@CeiBob 

Create this measure. This will work with or without relationship 

Qty Remaining = 
IF(
    HASONEVALUE( 'amount deployed'[Location]),
    VAR __ModelSelected = VALUES( 'amount deployed'[Model] )
    RETURN
    CALCULATE(
        SUM('amount remaining'[Qty]),
        'amount remaining'[Model] IN __ModelSelected
    )
)

[CeiBob]

Fowmy,

Thank you for this reply. I have studied how this works and have found out how I can solve many different issues due to this information! 

-CeiBob