Forum Discussion

praveen_k's avatar
praveen_k
Icon for Helper I rankHelper 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
praveen_k's avatar
praveen_k
Icon for Helper I rankHelper 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())