Forum Discussion

praveen_k's avatar
praveen_k
Helper I
10 years ago

IF to select a column value

I am trying to use a IF statement to select a column. I have a measured column which calculates percentage change. When the percentage change (measure column) is greater than 0, ID column should be se...
Need Help
Neuro81's avatar
Neuro81
Helper I
10 years ago

Hi Anonymous

Just a quick note on your formula regarding best practise

we should avoid putting the Table name next to the measure
ref: top 5 best practise tips

praveen_kAs Eno suggested your calc column should work, but I'd suggest appending the result with something so that the reader knows that the value returned is either the Id or the result of a mesaure

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Neuro81 Thanks for pointing that out. I just used the quick defaults on this one, but I typically have been referencing my calculated columns the same as normal columns (with table name), and measures as the only outlier (no table name). Must have mis-read this in my reading.

  • praveen_k's avatar
    praveen_k
    Helper I
    10 years ago

    Anonymous Neuro81 Thanks for your inputs. 

     

    This is the actual measure calculation. 

     

     

    I tried using your expression and this is what I get - 

     

     

    On the reports, I would like to view the ID column when when measure2 > 0 and Null/Blank when measure2 < 0. 

     

    Hope this clarifies my original question. 

    • praveen_k's avatar
      praveen_k
      Helper I
      10 years ago

      Correction to the above reply - 

       

      On the reports, I would like to view the ID column when when measure1 > 0 and Null/Blank when measure1 < 0. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        praveen_k This initial code is for a Calculated Column.

         

        This should work for a measure: 

        AsMeasure = IF([measure1] >= 0, VALUES('table'[id]), BLANK())