DAX Filtering with multiple measures

Anonymous — Thu, 28 Apr 2022 14:17:07 GMT

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?

Re: DAX Filtering with multiple measures

johnt75 — Thu, 28 Apr 2022 15:22:00 GMT

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.

topic Re: DAX Filtering with multiple measures in DAX Commands and Tips

DAX Filtering with multiple measures

Re: DAX Filtering with multiple measures