Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
  • MFelix's avatar
    MFelix
    6 years ago

    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:

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

What is the version of PBI that you are currently using?

 

If i'm not mistaken starting in May there is the possibility to have conditional formatting on the totals and sub totals.