Divide one row with the sum of two other rows

[oscarca]

Hello Community,

Is it possible to divide the sum of Scrapped Qty with Manufactured Qty and place the reslut in the first row of Quality Index i.e (50 + 150) / 1000 = 0.8. Right now it takes 50/1000 = 0.95

So what I have done is the following:

Manufactured Qty Filtered :=SUMX(FILTER('Dummy',Dummy[FirstOperation] = 1),[Manufactured Qty])

Quality Index :=DIVIDE([Scrapped Qty],[Manufactured Qty Filtered])

[tamerj1]

@oscarca 

Is this a pivot table or source data table? What are the fields? Are they source data columns/values or measures? What are planning to create, a calculated column or measure?

how many records you have? If many recods you want the same result ( the value of next row) for all rows? What is the next row? Is it something related to operation no.? Is the operation no. A sequential unique number?