CALCULAR SUBTOTALES EN UNA MATRIZ

Hi Macesa ,

I'll show you a workaround to do it:

First create a table such as below:

Putting all the fields of column "Municipio" with nu3 rows of "subtotal" in it ,adding an index column in query editor,then modify your measure as below:

Measure 2 = 
IF (
    ISINSCOPE ( 'Table (3)'[Column1] ),
    IF (
        FIND ( "total", SELECTEDVALUE ( 'Table (3)'[Column1] ), 1, -1 ) > 0,
        VAR currentTotalIndex =
            MIN ( 'Table (3)'[Index] )
        VAR lastTotalIndex =
            CALCULATE (
                MAX ( 'Table (3)'[Index] ),
                FILTER (
                    ALLSELECTED ( 'Table (3)' ),
                    'Table (3)'[Index] < currentTotalIndex
                        && FIND ( "total", [Column1], 1, -1 ) > 0
                )
            ) + 0
        RETURN
            CALCULATE (
                SUM ( 'Table (3)'[value] ),
                FILTER (
                    ALLSELECTED ( 'Table (3)' ),
                    'Table (3)'[Index] > lastTotalIndex
                        && 'Table (3)'[Index] < currentTotalIndex
                )
            ),
        SUM ( 'Table (3)'[value] )
    ),
    CALCULATE (
        SUM ( 'Table (3)'[value] ),
        FILTER ( 'Table (3)', FIND ( "total", [Column1], 1, -1 ) = -1 )
    )
)

Finally you will see:

Here is the related .pbix file.