Been beating my head against the wall. What am I missing?
Trying to create a measure to count active records below the median:
=Count (if (InCareNow=1 and SpellDays<Median(Total SpellDays), SpellID))
The problem is that the nested aggregation is scoped over all records, but I want the median just for the group of records associated with the dimensional value. I want to remove the "Total" qualifier from the inner aggregation but this is not allowed. My tiny brain does not comprehend why.
I have tried using Aggr but ran into the same issue. Any help would be appreciated. Thank you!
