How to count number of sales per client and accumulated sales per client

[ultimathor]

Hi,

I have a normal sales table that includes transaction number, date, amount, user-email and a bunch of other columns. I want to calculate two more columns in PP.

The first column should count how many total purchases have been made by the particular user-email of that row. The reason is that I want to make an analysis across different countries to see if there is a difference in number of sales per user.

The second column should count how many purchases have been made by the particular user email of that row up until and including this particular sale.

I am sure the answer is quite simple but as I'm new to PP I can't seem to figure it out. Suggestions highly appreciated .

Thor

 

[Laurent C]

I can confirm the other arguments are ok. Not very surprising since ALLEXCEPT( Sales, Sales[user-email] ) and ALL ( Sales[date] ) do not require - or more precisely ignore - any filter context.

The FILTER expressions in these case are indeed much cleaner.