Forum Discussion
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? ...
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
1. Create calculated table.
Table2 =
DISTINCT('Table'[Class])
2. Create a relationship between the two tables.
3. Create measure.
Measure 2 =
IF(
[Measure] = BLANK(),1,[Measure])4. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Liu,
When I tried to apply it, it shows the error "A single value for column '%' for table DB_Disponibilidad cannot be determinated.
This is the formula for the column %. 'If function' were quoted just for try another way but it's the main formula.