Forum Discussion
Solved
Measure for Generating Custom Text
Hi all, I am trying create a measure that will generate a specific word, “Meets”, when certain values are present. In Column “Grade”, there are four possible values: A, B, C and D. I would like t...
Hi, if each row has only one grade value A, B, C, or D, try measure below and 'Show items with no data' for Names.
Measure=
IF (
CALCULATE ( COUNTROWS ( FILTER ( Table, Table[Grade] IN { "A", "B" } ) ) ) > 0,
"Meets"
)
Hi, if each row has only one grade value A, B, C, or D, try measure below and 'Show items with no data' for Names.
Measure=
IF (
CALCULATE ( COUNTROWS ( FILTER ( Table, Table[Grade] IN { "A", "B" } ) ) ) > 0,
"Meets"
)
MasonMA , you came through again! Worked exactly as I wanted. Thank you!!!