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 tamerj1 - thanks for the quick reply.
I definitely considered that, and updated the values on some test records manually rather than through our Java app, with the same result.
I think SELECTEDVALUE returns blank for most of the rows as a result of finding many values. Please Try measure:
SELECTEDVALUE('db student_record'[letter_grade])
and see what results you receive.