How can I use the calculate formula using two filters of different columns?

[4pepesanchez4]

First of all, thanks for the help. What I want is to add all those amounts that make up "Sueldos y Salarios" (Wages, Comision, Goals, etc) that are in one column but that do not take what are indeminzations, which is within "Saldos y Salarios" but with another breakdown in another column.

Formula that I am currently using and that indeminzations are included:

The breakdown of indeminations is as follows:

How can I continue to add all the concepts of "Salarios and Sueldos" except those that are "1.3 Indemnizaciones"

Thanks!!!

[artemus]

You can use the conditional column button under add column. Just create a new column where if your categorization column indicates exclusion, put null or 0, otherwise the value of the column you want to sum. Then just sum that new column.

[Fowmy · Accepted solution]

@4pepesanchez4 

You can use a similar pattern as follows:

M = 

CALCULATE (
    [total sales],
    Customer[Gender] = "Male",
    Customer[Cars Owned] <> 2
)