Count if the sum is greater than 2

[q11hhg]

Hi there, could you please help me 

I want to know the distinct number of customers for the event type ='Login'  and sum of total event >2.

[agigliotti · Accepted solution]

Hi @q11hhg ,

You can use the below expression:

=count( {< [Event Type] = {'Login'}, [Customer ID] = {"=sum([Total Event])>2"}  >} distinct [Customer ID] )

I hope it can help.

Best Regards

[q11hhg]

Hi @agigliotti  Thank you but it gives me the same result as using : =
Count(distinct{<[Event Type]={'Login'}>}[Customer ID])

[agigliotti]

are you sure? that  would means that all customers with 'Login' as event type have the sum of 'Total Event' > 2.
is 'Total Event' a table field name?

[q11hhg]

HI @agigliotti  yes it is  a table field name

[agigliotti]

ok then as i said above in this case both expressions give the same result, but they have not the same meaning of course...