SUM() Function not aggregating accross time

[SQLBI]

Hi,

I have 2 calculated measures, one which should return a value for the given period, the other the cumulative value to date.

My syntax is as follows:

Period: ([Measures].[Quantity], [DimAction].[Action].&[1])
Cumulative: SUM([Measures].[Quantity], [DimAction].[Action].&[1])

Can anyone suggest where i may be going wrong as i'm struggling to see it!

Thanks in advance.

Cheers,
Leigh

"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem

 

[MDXer]

what is [DimAction].[Action].&[1]?

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[SQLBI]

Sorry, my Fact table has an ActionID to denote Invoice, Upload etc.

I need to filter this calculation to exclude fact rows that don't have a key value of 1 for ActionID



Cheers,
Leigh

"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem