
1. Re: Filtering by Condition Problem
Michel Caissie Jul 17, 2018 9:55 AM (in response to Scott Robinson)Scott,
I suggest the following calculation for the filter shelf.
IncidentHaveNoOpen =
{FIXED [Incident #]: MAX( if [# Open WO] > 0 then 1 else 0 end )} = 0
So for each row of an incident, if Open is > 0 return 1, then get the MAX of this value for all rows of the incidents, if this MAX = 0 return true.
As you can see on the sheet ValildateData , this return false for every row of Incident 704199, while you previous calculation returns Hide for only two of the 4 rows of this incident.
Your filter returns a per row value, while using the lod {FIXED} function , we get a per Incident value that is applied on every row of the incident.
You can see the final result on WO Tally (2).
Michel

Incident  WOs.(mc)twbx.twbx 139.5 KB


2. Re: Filtering by Condition Problem
Scott Robinson Jul 17, 2018 1:03 PM (in response to Michel Caissie)Michel,
Thank you very much! This worked for me. As a side note, when I applied this formula in my actual data, it didn't like that I was aggregating an already aggregated calculation, so I had to remove MAX from the calculation to make it work.
Thanks again.

3. Re: Filtering by Condition Problem
Michel Caissie Jul 17, 2018 1:10 PM (in response to Scott Robinson)If #Open WO is already an aggregation then you could simplify with
{FIXED [Incident #]: [# Open WO] } > 0