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:
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.
MFelix
Super User
Super UserHi 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: