Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

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

 

 

 

1 ACCEPTED SOLUTION
Stachu
Community Champion
Community 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



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

View solution in original post

2 REPLIES 2
Stachu
Community Champion
Community 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



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Anonymous
Not applicable

perfect thanks

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors