Switch() function not working for all categories

[Jk29297]

I am using a switch function to display data in a certain order and tag certain values to measures.  however, the result does not display the first and last category.  Here is the DAX

Report Value = (IF (AND (MAX ( Main[Is sum])=2,[Filtered]),

    BLANK (), SWITCH(MIN(Main[Is sum]),

               1, [OpeningBalance],

               2, (CALCULATE(SUM(Data[Debit/Credit Amount])),

               3,(CALCULATE(SUM(Data[Debit/Credit Amount])),

               4,[ClosingBalance]

               )))

________________________________________________________________________________

Filtered = ISFILTERED(Submapping[Sub_grouping])

result is

Opening balance and Closing balance are not shown.  Each category is defined in the Main table and mapped to same numbers in Is Sum column.  The total appearing as row subtotal is on.

any guidance is appreciated.

[Jk29297]

Adding further information, the relationship of tables are:  

further, the table Main has the following columns and data:

The table matrix output filters are :

[Wilson_]

Hello Jk,

Please help us help you.