overwrite visual filters in calculated column

When you say computers alone, do you mean to apply the filter for that category alone ane everythign else remains  the same?  Would have been easier for us to understand if you gave us a sample data and from the same sample data, your expected result.

VAR _computersOnly =
    CALCULATE (
        SUM ( tbl[value] ),
        KEEPFILTERS ( 'Product'[category] = "computers" ),
        KEEPFILTERS ( Countryregion[countryregion] = "Canada" ),
        KEEPFILTERS ( occupation[occupation] = "clerk" )
    )
VAR _other =
    CALCULATE (
        SUM ( tbl[value] ),
        KEEPFILTERS ( 'Product'[category] <> "computers" )
    )
RETURN
    _computersOnly + _other

Note: if filters are from the same table, there's no need to use multiple KEEPFILTERS for that table. Example: 

 KEEPFILTERS ( 'table'[category] = "computers"  &&  'table'[countryregion] = "Canada" )

Hi han_rj ,

To have the sales amount remove the visual filters when the product category is "Computer", you can leverage the following DAX measure for sales amount:

SalesAmount_OverrideComputers =
VAR IsComputers = SELECTEDVALUE('Product Subcategory'[product_category_new]) = "Computers"
RETURN
IF(
    IsComputers,
    CALCULATE(
        SUM('Sales'[SalesAmount]),
        REMOVEFILTERS('Product Subcategory')
    ),
    SUM('Sales'[SalesAmount])
)

If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

Thanks,

Samson