Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
This is my expression.
Count(if(ACTIVE='YES',customers))
But I want to add [type]={'PAF'} add count . How can i do it ?
Count(if(ACTIVE='YES',Count({$<[type]={'PAF'}>} [customers]))) this one throwing error.
Thanks in advance
Hi,
Try this.
Count({$<[type]={'PAF'},ACTIVE={'YES'}>} [customers])
Regards,
Kaushik Solanki
tried but it doesn't give the exact count what i'm looking .
Thanks for your response
Thanks,
Selva
Hi Selva,
With if try this:
=Count(if(ACTIVE='YES' and type= 'PAF',customers,null())
With set analysis is the answer, that kaushik.solanki wrote. That expression should return the same with count+if.
G.
Hi Gabor Tarnoczai,
Thanks for your response.
Count(if(ACTIVE='YES',customers)) this gives me -- 150 in the filter I've selected type (PAF).
If I use your expression
Count(if(ACTIVE='YES' and type= 'PAF',customers,null()) -- it gives more than 150 not even close
Thanks,
Selva
It is strange.
What do you get, when the measure is =count(customer) and apply the two selections with filter pane?
The expressions and the filtered result should be the same.
G.
Working Thanks for your help
I hoped so