Forum Discussion
IF to select a column value
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.
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.
praveen_k This initial code is for a Calculated Column.
This should work for a measure:
AsMeasure = IF([measure1] >= 0, VALUES('table'[id]), BLANK())
Error Message:
MdxScript(Model) (1, 51) Calculation error in measure 'Table'[Measure2]: A table of multiple values was supplied where a single value was expected.
Anonymous Neuro81
I tried to choose table and card visualizations on the report to display measure2 value, and I see this error.
Am I doign somehing wrong ?
praveen_k If you are going to filter it down to see the individual rows, you can use the original calculation as a calculated column. The slicer works with that.