Forum Discussion
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...
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.