Measure issue

[Rigolleto]

Hi,

I built a measure to calculate sales, everything if working good when the criterial is for a specific Week but, when I do select a more that one week then it is got a little crazy, let show you some values:

For this example if I show the values for a specifc week everythig work prefectly but, If I select the total change, the total value shoud be 206,765, as the screenshot show but, if I select two week the value showing is 242,262, this is incorrect and wierd, I did do some math I was able to see that the difference is 35,497, and this the result of substract 121,231-85,524 = 35,497, when the calculation is done then the mesure add up the 35,497 to the total = 242,262.

Any sugestion ?

I am using a Max because the values has being duplicated for every single row

[blopez11 · Accepted solution]

It would help to see the calculation for your measure, a sample of the what the data looks like in your fact table, and possibly a picture of your model