Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

A Simple Calculated Column With IF Statement

I'm having a really hard time with a seemingly simple calculated column.  I have a table representing route data with rows/values indicating picks, drops, lunches, leave base, return base, etc.  Ther...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

As Ashish_Mathur and Nick_M suggested, you should make sure you created a calcuated column rather than a measure with above formula. If you want to new a measure to evaluate every row and indicating whether the activity is a pick, you need this formula:

ISPick = IF( SELECTEDVALUE('Manifest'[Activity]) = "Pick", 1,0 )

Best regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

All,

 

I'm definitely using a calculated column and NOT a measure so still not sure why this is happening.

 

Since I can't get beyond this, I think I'll have to approach things differently and just create the field directly from the datasource rather than create it in the power bi model.

 

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    if you can upload a sample I can take a look.  Should be relatively straight-forward.