Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to replace empty cells in matrix with another value?

Grettings,   I'm trying to fill this empty cells on this table with the value "100%". I've already applied "ISBLANK" and "+0" at the end of the formula. Is there any other way to fill these cells? ...
DAX
empty cells
empty columns
sokg's avatar
sokg
Icon for Solution Supplier rankSolution Supplier
4 years ago

if(isblank(yourmeasure),1,youmeasure)

 

Hopefully this is what you are looking for!

bcdobbs's avatar
bcdobbs
Icon for Community Champion rankCommunity Champion
4 years ago

Nothing wrong with that measure - it's exactly what I've just done in a demo file.

 

Slightly confused by "The values  "%" showed  are a  calcutated column of two measures." Can you elaborate as I think issue will be how other things are being combined.