Numerous Subtotals Formula

Hi mibu,

Make the following change in the table CAT:

CATID

Now add the following measure to your model

CALCULATION_ =
SWITCH (
    TRUE ();
    SELECTEDVALUE ( CATID[ID] ) = 1; CALCULATE ( SUM ( ABCTEST[UNITS] ); ABCTEST[CONFIG] = VALUES ( CATID[CAT] ) );
    SELECTEDVALUE ( CATID[ID] ) = 2; CALCULATE (
        SUM ( ABCTEST[UNITS] );
        FILTER ( ALL ( ABCTEST ); ABCTEST[CONFIG] IN { "A"; "B" } )
    );
    SELECTEDVALUE ( CATID[ID] ) = 3; CALCULATE ( SUM ( ABCTEST[UNITS] ); ABCTEST[CONFIG] = VALUES ( CATID[CAT] ) );
    SELECTEDVALUE ( CATID[ID] ) = 4; CALCULATE (
        SUM ( ABCTEST[UNITS] );
        FILTER ( ALL ( ABCTEST ); ABCTEST[CONFIG] IN { "C"; "D"; "E" } )
    );
    SELECTEDVALUE ( CATID[ID] ) = 5; CALCULATE ( SUM ( ABCTEST[UNITS] ); ABCTEST[CONFIG] = VALUES ( CATID[CAT] ) );
    SELECTEDVALUE ( CATID[ID] ) = 6; CALCULATE (
        SUM ( ABCTEST[UNITS] );
        FILTER ( ALL ( ABCTEST ); ABCTEST[CONFIG] IN { "A"; "B"; "C"; "D"; "E"; "F" } )
    );
    SELECTEDVALUE ( CATID[ID] ) = 7; CALCULATE ( SUM ( ABCTEST[UNITS] ); ABCTEST[CONFIG] = VALUES ( CATID[CAT] ) );
    SELECTEDVALUE ( CATID[ID] ) = 8; CALCULATE (
        SUM ( ABCTEST[UNITS] );
        FILTER ( ALL ( ABCTEST ); ABCTEST[CONFIG] IN { "G"; "H" } )
    )
)

 This can probably be simplified, but since I took so long to answer you I think is better to share this result.

I will try to improve this later on but this is working currently.

Regards,

MFelix