Calculate total sales per customer and exclude certain customers

[RossS]

Hello,

I would like to create a column or measure that first caluclates the total sales for each customer, but then excludes certain customers.

Amount	Customer_no
£865.40	John
£656.00	Harry
£223.67	Harry
£12,233.89	John
£23,423.87	Rachel
£767.34	Rachel

If all information is stored in the same table, and i wanted to know the total sales for all customers, but exclude John, how would I write that?

The table is named Customer_Ledger_Entries_Excel.

I believe I would start with CALCULATE(SUM(Customer_Ledger_Entries_Excel[Amount]),

[anmolmalviya05]

Hi @RossS , please try below measure:

Total Sales (Excluding John) =
CALCULATE(
SUM(Customer_Ledger_Entries_Excel[Amount]),
Customer_Ledger_Entries_Excel[Customer_no] <> "John"
)

[RossS]

Thank you for this.

Can I also please ask, if I want to exclude data in the column that contains certain values, such as data that contain '0', how can I do this?