Forum Discussion

DCELL's avatar
DCELL
Icon for Resolver I rankResolver I
6 years ago
Solved

Another running total puzzle

PBIX: https://drive.google.com/file/d/1qQPbUKYFdpr1FMSLQ5Xf5lMfMszB_8yl/view?usp=sharing EXCEL: https://drive.google.com/file/d/1WdpHyK54pwY99za2YObX0fCc8tV_QYYB/view?usp=sharing Hi! I've looked...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi DCELL ,

     

    Or What you want is this?

    Measure = 
CALCULATE(
    SUM(Sheet2[amt]),
    FILTER(
        ALL(Sheet2),
        Sheet2[Country] = MAX(Sheet2[Country])&&
        Sheet2[Date] <= MAX(Sheet2[Date])
    )
)

     

    Best regards,
    Lionel Chen

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

     

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi DCELL ,

 

Or What you want is this?

Measure = 
CALCULATE(
    SUM(Sheet2[amt]),
    FILTER(
        ALL(Sheet2),
        Sheet2[Country] = MAX(Sheet2[Country])&&
        Sheet2[Date] <= MAX(Sheet2[Date])
    )
)

 

Best regards,
Lionel Chen

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

 

DCELL's avatar
DCELL
Icon for Resolver I rankResolver I
6 years ago

v-lionel-msft Your 2nd solution worked!! I had to remove the account column to get past the extra, double aggregation problem as you said