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

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

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

      LotteLaugesen 

      In this case use

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

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

        tamerj1 

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