Forum Discussion
SWITCH Statement for Quick Measure
Hi all, I'm trying to create a new measure that will return 1 or 0 based on the value of a column, so that I can then use that measure to do some conditional formatting on tables fields. Here's ...
Hi again tamerj1 - revisiting this as it's still not working. Wanted to provide some context with some screenshots to hopefully help.
1 - Cole is highlighted in red in the table on the left. But the table on the right, all rows are not in red.
2 - If I change his Working at Heights grade from an "EX" to a "P", the report works as intended. i.e. His row in the table on the left is not highlighted in red (it's slightly grey only because it's currently selected).
3 - This is the conditional formatting on the columns for the table on the left (only showing the Mobile column here).
4 - This is the conditional formatting on the columns for the table on the right (only showing Course Name column here) .
5 - This is the custom column "Letter Grade Number" that I'm using in the conditional formatting for the fields in both tables
So the thing is, that custom column and the conditional formatting is working for the table on the right. Because above, Cole's Working at Heights record with an "EX" isn't showing up as red. But the custom column and conditional formatting isn't working for the table on the left.
Any help, again, much appreciated.