When user selects first cyclic dimension , highest value gets highlighted in Yellow for each row respective to that.
When user selects second cyclic dimension , highest value gets highlighted in Yellow for each row respective to that.
Where as If we see first 2 rows , the color highlight gone away
When user hides second cyclic dimension , still the color highlight gone away for the first 2 rows
Highlight is done by using Chart- expression - Background Color
if(count(distinct [Sales ID])= Max(total <[Sales Manager],[Sales Guy]>aggr(count(distinct [Sales ID]),[Sales Manager],[Sales Guy],[Year-Month])),yellow(),white())
Note:- I have multiple column in cyclic dimension. 3 cyclic dimension is used
Please help on this .