Fill in with zero white spaces without losing context

[Syndicate_Admin]

Good afternoon everyone, I have a matrix that has blank spaces as seen in the picture.

When I add a new measure the following measure:

Measure 2 = COALESCE(SUM(FACT_TRANSACCIONES[NU_IMP_TRX_APP]),0), all values that have the lookup tables (dimension) in the array are added with the "0" as the value.

Could you help me as I avoid adding the columns and rows that I initially did not have them?

From antenamo thank you very much for the suggestions.

[AllisonKennedy]

@Syndicate_Admin @jasencio 

You need to find the context and create a measure that calculates that (for example the Total or Subtotal columns).

Subtotal = CALCULATE( [Measure] , ALL( tablename[columnname]) )

Where tablename[columnname] is the column that's used in the columns of your matrix.

Then add a new measure:

IF( [Subtotal] >0, 0 + [Measure])