to calculate sum of column on filtered rows

[tahira_ali_28]

Hi,

I have a table with multiple columns but i want to performa calculation on 2 columns. here is the sample data.

I want to find the last non zero value in column A and then get the sum of all the values in column B starting from Last non-zero value of column A till all the rows with 0 values in column A. In short, calculation needs to be performed on highlighted area only.

Please let me know how can i do that. Appreciate any help.

Thanks in Advance

[Fowmy · Accepted solution]

@tahira_ali_28 

Please create the measures as follows:

A_S Last = 
VAR _LastIndex =  CALCULATE( MAX ( Table1[Index] ) , Table1[A_S] <> 0 )
RETURN
CALCULATE(
    SUM(Table1[D]),
    Table1[Index] > _LastIndex
)

[tahira_ali_28]

Thanks alot @Fowmy .. This solution solved my problem.

Thanks for your help.

Regards