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!