Replacing blank cells in Matrix visuals

Hi Anonymous,

You can refer to following steps to achieve your requirement.

1. Add new table to extract sub div value from original table.

T3 = VALUES(T2[Subdiv])

2. Use original table div and new table subdiv to create a matrix visual.
3. Write a measure to calculate corresponding value and replace blank records as zero and drag to matrix visual value field.

M1 =
VAR result =
    CALCULATE (
        SUM ( T2[Value] ),
        FILTER (
            ALLSELECTED ( T2 ),
            [Div] IN VALUES ( T2[Div] )
                && [Subdiv] IN VALUES ( 'T3'[Subdiv] )
        )
    )
RETURN
    IF ( result <> BLANK (), result, 0 )

Notice:

1. you can replace '0' in if statement as any value. if you try to use text value replace , measure result type will convert as text which not able to direct used in other calculation.

2. themistoklis's solution works for existed blank records(e.g. A,3, ), if these blank records not real existed in your table, it not works.

Regards,

Xiaoxin Sheng