Forum Discussion

barragan82's avatar
barragan82
Helper II
10 months ago
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 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!!

Tips and Tricks
  • MasonMA's avatar
    MasonMA
    10 months ago

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

     

     

2 Replies

  • MasonMA's avatar
    MasonMA
    Super User
    10 months ago

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