Forum Discussion

LotteLaugesen's avatar
LotteLaugesen
Icon for Helper V rankHelper V
4 years ago

Problem with running total

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 ...
needs help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
LotteLaugesen
Icon for Helper V rankHelper V
4 years ago

Hi Anonymous 

 

Unfortunately it just made it worse ðŸ˜‰

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi LotteLaugesen ,

     

    Please share pbix so that we could test formula.

     

    Best Regards,

    Jay