Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Filtering with multiple measures

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?
 
DAX
Filter using a measure
  • johnt75's avatar
    johnt75
    4 years ago

    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.

1 Reply

  • johnt75's avatar
    johnt75
    Super User
    4 years ago

    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.