Sum measure is cannot be filtered by year

[fanhui3]

Hi, 

I am trying to compare a companies' operating cashflow (10 years of data) with it's capital expediture (5 years of data). I created a sum measure for each of them. However, when I put them graph, either of the measure is not filtered by the year (depend of the number of years I display) and instead, reflected the grand total across the year. 

May I know what did I do wrong? Thank you.

[v-frfei-msft]

Hi @fanhui3 ,

We can create a meausre as below to get the running total.

Measure = 
MAX ( 'Table'[Opearting  Cash Flow] )
    + CALCULATE (
        SUM ( 'Table'[Spending] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Year] <= MAX ( 'Table'[Year] ) )
    )

[fanhui3]

Hi Sorry, that's not it. I want it to display operating cashflow against the capital spending for the respective years. However, no matter what i try, one of the 2 values are displayed in total sum. I have re-displayed both tables in table format side by side for comparison. (see below). 

I could send you a copy of my powerbi dashboard. Maybe it would be easier if we all have the same file to take reference to? Thank you. 

[amitchandak]

Which graph are you trying? Is it muti card KPI? Put into the matrix and check the values.

Ideally, You Fact/s should be joined with date dimension and you are viewing by year.