Add custom Total row

akhilduvvuru 

We have to break the link when calculating the total which we can do using REMOVEFILTER like this.

Sales with total = 
VAR _Category = SELECTEDVALUE ( DIM_TABLE[Category] )
RETURN
    SWITCH (
        TRUE (),
        _Category = "Fruits Total",     CALCULATE (
                                            SUM ( FACT_TABLE[SalesAmount] ),
                                            REMOVEFILTERS ( DIM_TABLE ),
                                            DIM_TABLE[Category] IN { "Apple", "Orange" } ),
        _Category = "Stationary Total", CALCULATE (
                                            SUM ( FACT_TABLE[SalesAmount] ),
                                            REMOVEFILTERS ( DIM_TABLE ),
                                            DIM_TABLE[Category] IN { "Pen", "Scale", "Ink Pot" } ),
        _Category = "Clothing Total",   CALCULATE (
                                            SUM ( FACT_TABLE[SalesAmount] ),
                                            REMOVEFILTERS ( DIM_TABLE ),
                                            DIM_TABLE[Category] IN { "Shirt", "Pant" } ),
        SUM ( FACT_TABLE[SalesAmount] )
    )