Cumulative Total

Hi MartynRamsden,

Thanks for providing the previous formula! It helped me  a great deal. 

However, I seem to have encountered another obstacle. 

I used the formula that is listed below and when i look at the data on a yearly basis, the graphs that I have for the year and the model are accurate but the graph showing the cumulative number of models by year and sub-region is wrong.

For example, in 2000, there were 8 machines and this is reflected correctly in the diagram showing the total number and the model since there are 5 HE and 3 LE (thus, 8 machines). However, this isnt reflected in the diagram which shows the number of machines by year and sub region, since the total number shown is only 5 (SEA NORTH) + 1 (SEA SOUTH) = 6. 

CumulativeTotal = CALCULATE(SUM('IB_SEAK HKM_HW'[Index]),FILTER(ALLEXCEPT('IB_SEAK HKM_HW','IB_SEAK HKM_HW'[Sub-region],'IB_SEAK HKM_HW'[Model],'IB_SEAK HKM_HW'[Account: Country]),'IB_SEAK HKM_HW'[Date Installed]<=MAX('IB_SEAK HKM_HW'[Date Installed])))

 

2

 

This table above verifies that I do have 3 machines in SEA South and 5 machines in SEA North.  '

1

 

Do you know why this is happening? Is there any part of the measure that I am using that causes this problem? I've also applied some model filters and this can be seen on the extreme right hand side of the above screenshot.

 

Thank you for your help!

 

Best regards,

JPY