Forum Discussion
lawada
Helper III
Helper IIIunable to replace blank with zeros in matrix
im trying to replace blank values with zeros in the following matrix : the measure im using: total users = CALCULATE(DISTINCTCOUNT(canceled_then_returned_cohort[user_id]))+0 note t...
As Fowmy points out, if there are no rows in the data table corresponding to a particular cell, then it can't return anything since there's nothing to evaluate. It doesn't matter if you add "+0" to the measure since it never gets called in the first place.
The solution to this is to use dimension tables to populate the rows and columns in the visual. I.e., a date table for the rows and some sort of index table for the columns. This way, the measure you put in the matrix cells lives in the cross-join of the dimensions rather than being limited to the subset that intersects with your data table.
