Problem with running total

[LotteLaugesen]

Hi 

Can anybody tell me what's wrong with my running total? Why doesn't it aggregate when I have different Currency LCU?
Can anybody tell me how to solve it? When I remove Currency LCU there is no problem.

My calculation:

BR 

Lotte

[Anonymous]

Hi @LotteLaugesen ,

Please use ALLEXCEPT() function on [Current LCU]

Acc. DKK Amount =
VAR RT =
    IF (
        [DKK] <> BLANK (),
        CALCULATE (
            'Misc calc'[DKK],
            ALLEXCEPT ( 'table', 'table'[Current LCU] ),
            FILTER (
                ALLSELECTED ( 'Dim Calendar' ),
                'Dim Calendar'[Date] <= MAX ( 'Dim Calendar'[Date] )
            )
        )
    )
RETURN
    RT

Best Regards,

Jay

[LotteLaugesen]

Hi @Anonymous 

Unfortunately it just made it worse 😉

[Anonymous]

Hi @LotteLaugesen ,

Please share pbix so that we could test formula.

Best Regards,

Jay

[tamerj1]

HI @LotteLaugesen 
Try to add ALL ( TableNam[Currency LCU] ) inside the CALCULATE function.

[LotteLaugesen]

Hi @tamerj1 

Thanks - It almost works 🙂

The first 2 lines are adding up, but below you can see that 2 other lines are not

Have you got any more other ideas?

[tamerj1]

@LotteLaugesen 

In this case use

ALLSELECTED ( TableNam[Currency LCU] ) inside the CALCULATE function.

[LotteLaugesen]

@tamerj1 

My calculation looks like this now, but it doesn't help 😞

[tamerj1]

@LotteLaugesen 

please try

Acc. DKK Amount =
VAR RT =
    IF (
        [DKK] <> BLANK (),
        CALCULATE (
            [DKK],
            ALLSELECTED ( FT_ARAP_Invoices ),
            REMOVEFILTERS ( 'Dim Calendar' ),
            'Dim Calendar'[Date] <= MAX ( 'Dim Calendar'[Date] )
        )
    )
RETURN
    RT

[LotteLaugesen]

@tamerj1 thank you for your time, but it didn't make any difference.

The final result is correct so right now I will go with this 😉

[tamerj1]

@LotteLaugesen 
Last trial

Acc. DKK Amount =
VAR CurrentDate =
    MAX ( 'Dim Calendar'[Date] )
VAR RT =
    IF (
        CurrentDate <> BLANK ()
            && [DKK] <> BLANK (),
        CALCULATE (
            [DKK],
            ALLSELECTED ( FT_ARAP_Invoices ),
            REMOVEFILTERS ( 'Dim Calendar' ),
            'Dim Calendar'[Date] <= MAX ( 'Dim Calendar'[Date] )
        )
    )
RETURN
    RT

[LotteLaugesen]

Thanks @tamerj1 but it didn't help