Hi Experts,
I am trying to create a measure where I check how many Categories within a Topic have a value of 5 in each of three Functions with my data structured like:
Load * Inline [
Topic, Category, Reporter, Function, Progress
T1, C1, Ralph, A, 5
T1, C1, Ralph, B, 1
T1, C1, Ralph, C, 5
T1, C1, Sam, A, 3
T1, C1, Sam, B, 5
T1, C1, Sam, C, 4
];
with additional entries for Topic (T1, T2, T3, ...) and Category (C1, C2, C3, ...).
My current attempt is:
count(distinct aggr( if( ( max({$<Function={'A'}>} Progress ) = '5' ) AND ( max({$<Function={'B'}>} Progress ) = '5' ) AND ( max({$<Function={'C'}>} Progress ) = '5' ), Category, (Category,Topic)))
But this seems to only work if I filter to a single Topic. Do you have any thoughts or suggestions?
Thank you very much!
