Forum Discussion
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:
2 Replies
- Fowmy
Super User
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
Post 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