DAX filter units by company

[Sleathbcn]

Hello, I would need help with a sales table. Let me explain, I have a unit sales table. In this table there are 5 companies, A,B,C,D and E. The units of company B are always incorrect. I would like to find a dax formula where the units of the companies add up without taking into account the units of B. Thank you very much.

[Sleathbcn]

Thank you, very much!! 👍

[DataNinja777 · Accepted solution]

Hi @Sleathbcn ,

I am not sure about your exact table and column names, but there are many ways to get your required output, and one of them is as follows:

Best regards,