Fill out Blank Values with another Calculation in a Matrix (Subtotals for EBITDA and EBIT)

Hi Rygaard ,

First you create the following measure

Measure = -1 * CALCULATE ( SUM ( 'FinansRecords'[Auto] ) ) / 1000

Then create the another measure 

'Actual with Profit & loss category =
IF (
    ISBLANK ( [MEASURE] ),
    SUMX ( ALL ( 'FinansRecord' ), [Measure] ),
    [Measure]
)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

This is gettign abit strange, with no connection between  the table hosting the ranges and no extra calculation i managed it.

it seems powerbi will fill out the first level based on my non connected support table based on my within range

and then then here comes the strange part it will arrange the correct accounts under that headline, this i can not fatom how it is doing but it works...

The formular i endet up using:

'Profitlossgroupe totals = CALCULATE(SUM(FinansRecords[Auto]),ALL(FinansRecords[F.G/LNo_AsNumber]),
FILTER(FinansRecords,(FinansRecords[F.G/LNo_AsNumber]>=MAX('Index$ (2)'[from]))),FILTER(FinansRecords,(FinansRecords[F.G/LNo_AsNumber]<=MAX('Index$ (2)'[to]))))*-1/1000