Sum rows depending value of other column

[GA_DO]

Hi there,

I am wondering how I can make a measure for the following issue:

The light blue line represents a niveau sensor, the dark blue line represents amount of produced boxes.

I want to make a measure that calculates the amount of produced boxes after the first moment the niveau sensor is 0(red cirkle).

To summarize, I want to calculate the difference between the red cirkle and the green cirkle (dark blue line). 

In my opinion there are 2 ways:

1. I know it takes arround 20 minutes before the the production of boxes stops. So I could say just take the differnece between the first row and 20 rows later.

2. Or I could see when the dark blue line stablelized. For example when 3 rows are the stable, take that value to calculate.

The problem is, I don't know how to make this measure and if this is even possible.

I hope someone is able the help me out!

[edhans]

You will need to provide data and some method of the math - 100% manual of how you would do it in Excel is fine. Then we can assist with the conversion to DAX logic.  But we have to have data.

How to get good help fast. Help us help you.

How To Ask A Technical Question If you Really Want An Answer

How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.

[GA_DO]

Thank you for your answer.

https://docs.google.com/spreadsheets/d/1EtEKdyhkzqIWh_sOEeffMZLhLkFFniLj/edit?usp=sharing&ouid=10464...

I hope you can open the data with this link, if not let me know.

In this excel file you can find 2 sheets:

- in the first sheet you can find niveau sensor

- in the second you can find amount of boxes

During "normal" production the value of niveau sensor is arround 5-8. When there is no production anymore, the niveau drops to zero. I want to know how many boxes are produced after the moment the niveau is zero. 

I hope my explaination is clear enough, if not let me know.

Thanks!

[Anonymous]

Hi @GA_DO ,

I can't access to your file, could you please grant me the proper access to it? Thank you.

Best Regards

[GA_DO]

I assume with this link you will be able to open the doc:

https://docs.google.com/spreadsheets/d/e/2PACX-1vRBGoERcR8pd--bbgCr_rYIbz8gbWahDKgWoBSSlww6HFCDG0Gt_...