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!