The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to Solution.
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
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
perfect thanks