Forum Discussion

LotteLaugesen's avatar
LotteLaugesen
Helper 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 no problem.

My calculation:

 

BR 

Lotte

 
 
needs help

11 Replies

    • LotteLaugesen's avatar
      LotteLaugesen
      Helper V
      4 years ago

      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's avatar
        tamerj1
        Community Champion
        4 years ago

        LotteLaugesen 

        In this case use

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

  • 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi LotteLaugesen ,

         

        Please share pbix so that we could test formula.

         

        Best Regards,

        Jay