What is the syntax of the query you are running (not the calculated member)? If you are using Excel you need to run a trace on the server to get the MDX query

The syntax looks correct so it will be a contextual problem eg you are using a different date than the one specified

Mack