DAX selected value on slicer cannot use in calculation

[gredsq456]

Hello,

My dynamically selected_splicer value is not filtering my postgres data table rows correctly.

I can singly select my selected_text in the splicer table and create a measure as

Select_Slicer = values('public security'[ticker])

I can display the selected_text in a card just so I coud make sure the slicer would work.

My data does not show up in the chart from my filtered postgres table because of the [Select Slicer]

Stock Prices = CALCULATE( AVERAGE('public daily_price'[adj_close_price]), filter('public security'[ticker], 'public security'[ticker] = [Select_Slicer]))

I can get my data to show when I statically filter my Stock prices as to "F" for example. However I would like to do this with my dynamically with my slicer.

Stock Prices = CALCULATE( AVERAGE('public daily_price'[adj_close_price]), 'public security'[ticker] = "F")

The selected value and filtered value is a text so I don't think it is a datatype issue.

[Fowmy]

@gredsq456 

Your code looks fine, can you check the relationship between the two tables?

[gredsq456]

Here are my two tables. This is a "natural" relantionship from postgres. 

- security (which I use to select a the "ticker" (id AND ticker are unique and linked)

- daily_price (adj_close_price). ticker_id (is many). The daily_price table is by row unique : 

the (ticker, price_date, adj_close_price)

The only thing I could suspect is if I directly select the "id" instead of the "ticker" with is one for one in the security table as to pull my data.