measure not showing count

[Anonymous]

Hi,
A question regarding my measure please.
I have impoted several tables
vw_Performance
pKey BandID Performance
fds 2 23%
gre 3 28%
ytr 14 56.9%
...

tblBand
BandID Low High
1 0 0.1
2 0.1 0.2
3 0.3 0.3
...

I have a measure which I tested with tblPerformance alone and works fine but this measure does not return any values when I connect vw_Performance.BandID to tblBand.BandID

Any suggestions please?

count vw =
COUNTAX(
FILTER(
vw_Performance,
[Performance] > SELECTEDVALUE(tblBand[Low]) && [Performance] <= SELECTEDVALUE(tblBand[High])
),
vw_Performance[Portfolio Key]
)

Thank you

[lbendlin · Accepted solution]

put your selectedvalues into variables 

count vw =
var low=SELECTEDVALUE(tblBand[Low]) 
var high=SELECTEDVALUE(tblBand[High])
return
COUNTAX(
FILTER(
vw_Performance,
[Performance] > low && [Performance] <= high
),
vw_Performance[Portfolio Key]
)

[Anonymous]

Thank you