Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Fill in with zero white spaces without losing context

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

jasencio_0-1643926460298.png

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.
jasencio_1-1643926653004.png

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.

1 Reply

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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])