Ahhh I see! right ok, you'll need to do something like the below, assuming you have a dimension called retailers and a dimension attribute called Retailer Name: COUNT(FILTER([Retailers].[Retailer Name], [Measures].[orders]>0)) This will give you the desired result. Alternatively I think you could even modify your original attempt to something like this and it work: SUM([Retailers].CurrentMember,CASE WHEN[Measures].[orders]>0)THEN 1 ELSE 0 END)
Hi Erez, are you saying you've created this as a calculated measure in the cube? What are you trying to achieve with this query? If you're taking a sum over this calculated measure, what you're actually doing is a COUNT of the number of measures that are > 0. Is this what you intended?
Ok so if I understand correctly you need to put a SUM around this calculation in order to get what you require. This is providing you have set up all your dimension relationships correctly between the fact. The other approach is to use the COUNT() and NONEMPTY() functions something akin to: (Psudo code) COUNT(NONEMPTY(, [Measures].[orders]))