MDX tuple not returning correct value

Question

I have a test cube with one dimension and one fact table.

Superbill Key on Fact Superbill references the Primary Key on Dim Superbills.

On my Fact Superbill measure group I have several measures, including one which is a Fact Superbill Count. Based on this measure, I create a calculated member called Generated Superbills as follows:

([Measures].[Fact Superbill Count], [Dim Superbills].[Is Void].&[No])

On the cube browser I create the following query that returns only one SuperbillKey, including the Fact Superbill Count and Generated Superbills. The results show the correct value for Fact Superbill Count (which is one since I am only getting one Superbill), but Generated Superbills show 23.

What am I doing wrong? Both should return 1.

Answer 1

I am not sure why it was not working, but I was able to find a solution for this. Superbill Key on DimSuperbills had a Key Value and a Name Value (the name value was not unique). I removed Name value and left only they key. I ran the MDX query after these changes and it worked.