cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
4pepesanchez4
Regular Visitor

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

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:

 

4pepesanchez4_0-1634476371586.png

 

The breakdown of indeminations is as follows:

 

4pepesanchez4_1-1634476538316.png

 

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

 

Thanks!!!

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@4pepesanchez4 

You can use a similar pattern as follows:

M = 

CALCULATE (
    [total sales],
    Customer[Gender] = "Male",
    Customer[Cars Owned] <> 2
)
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
artemus
Microsoft
Microsoft

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
Super User
Super User

@4pepesanchez4 

You can use a similar pattern as follows:

M = 

CALCULATE (
    [total sales],
    Customer[Gender] = "Male",
    Customer[Cars Owned] <> 2
)
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors