Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create a measure to count customers who aged between 10 and 50 using set analysis, here's my script:
Count({$<Age={">10<50"}>}distinct(CustomerId))
The script looks ok, however the result I get is the total number of customers, not those who aged 10-50.Can someone tell me what's wrong?Thanks a lot!
I agree that the expression looks OK. How about your data model? Is the CustomerId a key field?
If it is - doing a count on it will give you wrong results....