What is the syntax of an expression with "if", "count distinct", comparing 2 values ?

[marieclaire]

Hi everybody,

i need to calculate a number of sales by distinct ID, comparing 2 values :
if(min(p.Contenu) <= num(p.Event),1)

Anybody could help me to use the right syntax ?

I tried many things as

count(distinct(if(min(p.Kiosque) <= num(p.Event),[Visites ID])))

Thank you for your help.

[Channa]

TRY

IF(min(p.Kiosque) <= num(p.Event),COUNT( DISTNCT [Visites ID],0)

[pradosh_thakur]

HI

It completely depend upon where you are using the expression . Still you may try this

count({<[Visites ID]={"=min(p.Kiosque) <= num(p.Event)"}>}[Visites ID])

Thanks

Pradosh

[Anil_Babu_Samineni]

Perhaps this?

count(distinct if(min(p.Kiosque) <= num(p.Event),[Visites ID]))