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 lcharlebois
you need to check your source data for visible and invisible spaces and characters. You need to use power quert to trim and clean the data. This could be the issue or one of many.
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.