Short answer is your fact table violates proper granularity. By definition a single fact must be unique based on the granularity of the dimensions. If it isn't unique then you are either missing a dimension or have not decomposed a dimension far enough. A cube aggregates measures across the dimensions. There is no such thing as a row in a cube so trying to create MDX based on SQL concepts will get you in trouble every time.