Forum Discussion
Conditional Formatting Highest Sub-Total
I've got a matrix in place at the minute using sub-totals for 10 pieces of data. One value is 13, the other is 11 but this can vary based on user input via filters I have in place. Is there a way...
Hi Anonymous ,
Try to create the following formula:
Measure = VAR temp_table = SUMMARIZE ( ALLSELECTED ( Table[cat]; Table[cat2] ); Table[cat]; "@Total"; SUM ( Table[value] ) ) RETURN IF ( MAXX ( temp_table; [@Total] ) = SUM ( Table[value] ); 1; 0 )the use the condititonal formating to equal 0 and 1:
Anonymous , I think new version it can apply to sub-totals too
I can add the conditional formatting, the problem is that when I go into the options to do this and choose to look at totals only, I have to put in a custom minimum value and maximum value which isn't what I need.
It needs to be able to look at the values being shown and determine of those, which is the highest and highlight it as such.
Using August 2020 release.
Hi Anonymous ,
Try to create the following formula:
Measure = VAR temp_table = SUMMARIZE ( ALLSELECTED ( Table[cat]; Table[cat2] ); Table[cat]; "@Total"; SUM ( Table[value] ) ) RETURN IF ( MAXX ( temp_table; [@Total] ) = SUM ( Table[value] ); 1; 0 )the use the condititonal formating to equal 0 and 1: