Forum Discussion

Shamatix's avatar
Shamatix
Icon for Post Partisan rankPost Partisan
5 years ago

Help with Measure - MAX IF in same measure?

Hi there,

 

So I have made a fairly simply measure and it works to a degree.

The measure goes as follows:

CheckExpected = IF(SUM(Merged[Value]) > [Forventet], 1, 0)
 
So I have a Matrix.
What I want to achieve is for the second column to light up red with conditional formatting as one of the "nested" numbers is higher than the third column
227 is larger than 150 so I want the header row (227) to light up red as well.
Can someone help me achieve this šŸ™‚
 

2 Replies

  • Shamatix 

    Conditional formatting for column headers is not available yet.  You can use the title text, font color or title background color to highlight.
    In my example, I made the title font color red if any value in VALUE1 column is found to be more than VALUE2. 
    Measure to apply for Font of the Title under :

    Flag = 
    IF(
        NOT(
            ISEMPTY(
                FILTER(
                    Table4,
                    Table4[Value2] > Table4[Value1]
                )
            )
        ),
        "RED"
    )

    Conditional Formatting

    Result

     

     







    • Shamatix's avatar
      Shamatix
      Icon for Post Partisan rankPost Partisan

      I am not talking about column headers, but all the values.

      Hopefully these pictures makes it a bit more clear what I want.

       

      I want the 227 "top level row" to be red as one of its "under values" exceeds the other number.

      So eventho 227 is less than 300 I want the 227 to be red as its "nested value" 227 is higher than 150.


      Hope that made more sense