Forum Discussion

CTW's avatar
CTW
Regular Visitor
8 years ago
Solved

Comparing column values with measure

Hi Power BI Professionals:   I'm trying to compare my measure with my columns to get another calculated column:                                   FrPY is a measure and Goal ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    CTW,

     

    You may add a measure as follows.

    Measure =
IF ( [FrPY] < MAX ( Table1[Goal] ), 1, 0 )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

CTW,

 

You may add a measure as follows.

Measure =
IF ( [FrPY] < MAX ( Table1[Goal] ), 1, 0 )
  • CTW's avatar
    CTW
    Regular Visitor
    8 years ago

    Thanks that worked!

     

  • sgovindarajan's avatar
    sgovindarajan
    Frequent Visitor
    8 years ago

    v-chuncz-msftThis worked for me. Can you tell me how adding MAX works though?