DAX Filtering with multiple measures

[shiltonen]

I have created some statistical measure for lower bound, quartile 1, median, quartile 3, and upper bound.  I would like to have a count  of the records that lay between these boudaries.  So, as an example, I created this:

COUNTROWS(FILTER(TechData, TechData[VALUE] >= TechData[Lower Bound] && TechData[AcceptanceTime] < Quartile1))

This returns a blank value.  I've discovered that if I put the actual value into the second part of the &&, I get the correct response.  So, this works:

COUNTROWS(FILTER(TechData, TechData[VALUE] >= TechData[Lower Bound] && TechData[AcceptanceTime] < 20))

Any ideas why it can process the first measure, but seems to have issues when the second is added?

[johnt75 · Accepted solution]

Not sure if this will fix it but try

Num rows =
var lowerBound = [Lower Bound]
var quartile1 =[Quartile1]
return COUNTROWS(FILTER( TechData, TechData[VALUE]> = lowerBound && TechDate[AcceptanceTime] < quartile1))

this will only compute lower bound and quartile 1 once, rather than having to recompute for each row of TechData.