Get First Occurence on Running Sum Measure

[SebboBI]

Hi P BI Com, 

I screened many threads for hours and even though some solution sound very close, so far I couldnt find a working one. I need your help! 🙂

My Case:

I have a table with a time column (in years) and many more columns that stand for different costs and revenues (not shown for simplicity).

I calculate a measure "EBITDA" which sums all revenues and costs.

Furthermore, I calculate the Running Sum of EBITDA, which shows the cumulative profitability over time.

My Problem:

Now I want to calculate the Break Even Point -> When is the exact time that this running sum is becoming profitable (Sum EBITDA > 0). It should actually be just a single value that I would like to display on my dashboard!

So far, I used a calculate expression that nests an if coniditon to calculate the exact point in time only if Running Sum EBITDA is > 0.

The calculation itself works correctly. However, it is in some weird "format" that I can not process correctly in any of the wanted visuals or furher calculations. The column sum "pretends" to be inifinity ?!?!

How can I get an expression that just returns the first real occurence of column "Break Even Point"?

I feel that part of my problem is that the measure uses the Running Sum which gives wrong values when evaluated in a sumx (line by line). The expression of the Running Sum is 

Running Sum EBITDA =

CALCULATE(

    [EBITDA],

    FILTER(

        ALLSELECTED('Time Series'[Time]),

        ISONORAFTER('Time Series'[Time], MAX('Time Series'[Time]), DESC)

    )

)

Data from the Screenshot:

Time	EBITDA	Running Sum EBITDA	Break Even Point
1	-1882920000	-1882920000
2	118486966	-1764433034
3	253469373	-1510963661
4	253469373	-1257494288
5	253469373	-1004024915
6	253469373	-750555542
7	253469373	-497086169
8	253469373	-243616796
9	253469373	9852577	9,96
10	253469373	263321950	9,96

[SebboBI]

Can someone help here? I am hard stuck 😞