I have calculated the avg. now the requirement is on any selection (Year, Month, Any dimension filter) based on RM% I need show only those records which have the RM% value greater than equal to Total Avg. RM% .
1: What is the total function you have applied on the above mentioned expression, is it auto or average?
2: Do you have PlantCode,[Material No],[Fiscal Month] as your dimension in the table ? If yes then aggr might not be needed in the case
I would request you to share a sample so we could provide you with a better solution. You are already using aggr 2 times. Like i said without seeing the dimension we can provide you an answer which might slow down your dashboard.