1 of 1 people found this helpful
You can encapsulate your [worker] filter in a table Calculation simply returning a worker , and use this calculation as the filter.
This way T will have to bring all the workers then execute the calculations.
And since the worker filtered is now the result of a calculations , it gets also the properties of the other calculations.
So instead of having;
-filter worker then calculate colors
-calculates everything , (colors and worker filter)
-filter worker (with appropriate color)
You would be able to do this by creating a table calculation and using it as filter - in the workbook attached you find calculation 1: lookup(min([Worker]),0).
In case anyone else is struggeling about why: The dataset will be filtered directly when setting a regular filter - by creating a filter based on the table calculation, the filter will be on the table instead of the data and thereby the numerator and denominator in the percentage calculation will be right.
Hope it will help you