Forum Discussion
IF to select a column value
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.
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 ?