Forum Discussion
DaX error when trying to view measure data
HI I have a measure
Measure = CALCULATE(view[c],ISBLANK(view[CS]= FALSE()))
the view[c] is another meaure which works on its own
view[CS] column return blank without error
but when I apply the above meaure " Measure = CALCULATE(view[c],ISBLANK(view[CS]= FALSE())) " it throighs an error
"MDXScript(model) (12,118) calculation error in meaure :DAX comparisons do not support comparing value of type text with values of type true/false . consider using the value or formate function to convert one of the values,
but I am not sure of syntax , could you help please?
thanks
ISBLANK operates on a column, not a boolean value
try thisMeasure = CALCULATE([c],NOT(ISBLANK(view[CS])))
it calculates [c] for all the rows in view[CS] which are not blank
2 Replies
- Stachu
Community Champion
ISBLANK operates on a column, not a boolean value
try thisMeasure = CALCULATE([c],NOT(ISBLANK(view[CS])))
it calculates [c] for all the rows in view[CS] which are not blank
- AnonymousNot applicable
perfect thanks