Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 this

    Measure  = CALCULATE([c],NOT(ISBLANK(view[CS])))

    it calculates [c] for all the rows in view[CS] which are not blank

2 Replies

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion

    ISBLANK operates on a column, not a boolean value
    try this

    Measure  = CALCULATE([c],NOT(ISBLANK(view[CS])))

    it calculates [c] for all the rows in view[CS] which are not blank

    • Anonymous's avatar
      Anonymous
      Not applicable

      perfect thanks