Forum Discussion

EstherBR's avatar
EstherBR
Helper III
10 months ago
Solved

Running total as a Tooltip

Hi,   I have the following table: I have created the following line chart with the cumulative sum of sales: Running Total = CALCULATE(     SUM(Sheet1[Sales]),     FILTER(         ALLSE...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    10 months ago

    Hi,

    Please try something like below.

    For this kind of semantic model, that has only one table, try using ALL DAX function.

     

     

    Running Total = 
CALCULATE(
    SUM(Sheet1[Sales]),
    FILTER(
        ALL(Sheet1[Date]),
        Sheet1[Date] <= MAX(Sheet1[Date])
    )
)

      

Jihwan_Kim's avatar
Jihwan_Kim
Super User
10 months ago

Hi,

Please try something like below.

For this kind of semantic model, that has only one table, try using ALL DAX function.

 

 

Running Total = 
CALCULATE(
    SUM(Sheet1[Sales]),
    FILTER(
        ALL(Sheet1[Date]),
        Sheet1[Date] <= MAX(Sheet1[Date])
    )
)