Measure for Generating Custom Text

[barragan82]

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 the word “Meets” to generate when A and/or B are present, even if C or D are present as well. However, if only C and/or D are present, I would like a blank return.

For example, when I filter by column “Name” and A and C are present, I would like the word “Meets” to appear. If I continue to filter by Name and only C and D are present, I would like a blank value.

Thank you all for your help!!

[MasonMA · Accepted solution]

@barragan82 

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"
)

[barragan82]

@MasonMA , you came through again! Worked exactly as I wanted. Thank you!!!