Filtering by the result of a Calculated Expression
I want to have a filter box to see and filter by the results of a calculated measure. For example, I'm looking at maintenance tasks required for an aircraft. I have a calculated expression (RangeMin(monthly interval, 12/ (flight_hour_interval / (avg(kmperyear)))
It tells me based on the utilization of an aircraft if the monthly limit or the flight hours limit will be reached first (and convert it into a monthly interval)
It works well but I want to filter based on the results of that calculation. I.e show all tasks due at 14 months.
Ive converted this calculation into a variable (lowest_Interval) and tried a nested if approach if(lowest_Interval = 14, '14 months', if(lowest_Interval = 15, '15 months', 'null')) Ect It's not working. Any tips??