Need YTD Line and Month Line - 'ALL' Not Working As Expected

[lg1551]

Hello,

I have a measure on my Y-axis and the Fiscal Year/Month on the X- Axis.

My measure is calculating correctly for each month along the X-Axis.

I've tried to create another measure (pointing at the same existing measure), but filtering ALL(Date) so that I get one continuos line for the Fiscal Year across all months. It should be the total for the Fiscal Year and display across all months.

The results though, are the same as my original measure and it calculates the measure for each month.

[Greg_Deckler · Accepted solution]

@lg1551 I'm guessing that you are using CALCULATE, try this:

Measure = 
  SUMX(ALL('Table'[Date],[Value])