I am looking to apply a filter based on values resulting from the following constant expression in a graph :
Sum ( { < Moment = {' Held '} >} [ Qt . BDA ] ) / Sum ( { < Moment = {' PLANNED '} >} AGGR ( distinct SUM ( DISTINCT [ Qt . BDA ] ) , Chv_Mom_Prod_Mês_Colab ) )
This expression will return percentages for each dimension. I would like to create a filter based on percentage , which , for example, by clicking the green button seep results that were > = 100 % ; clicking yellow values between 80 % and 99 % and clicking the red values below 80 % .