Forum Discussion

Henryk's avatar
Henryk
Frequent Visitor
4 years ago

Running total display only increment with filter by date

Hi,

I have graph slicer and I need display there running total by date. 

I have a slicer on it so I can filter the date range dynamically:

 


if I display all data without filtering, then everything works and shows the running total of the profit. But if I filter the data with the date slicer shown above, the running total is not displayed, only the increment for the day.
below is the graph for all dates without filtering:

 

and if I filter it by date (even if only one day less) then the data will change and display only increment:

 

For measure I try this formula:

Monthly Running Total =
IF(
[profit] <> BLANK(),
CALCULATE(
[profit],
FILTER(
ALL('table'[date]),
'table'[date] <= MAX('table'[date])
)
)
)
 
or this formula:
Monthly Running Total2 =
CALCULATE(
    [profit],
    FILTER(
        ALLSELECTED('table'[date]),
        ISONORAFTER('table'[date], MAX('table'[date]), DESC)
    )
)

 

But still some result when filter by date. How resolve it?

 

 

 

 

 

Need Help

2 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Henryk ,

     

    Please try to change the cross filter direction from single to both. Or replace the field in the date range slicer with the field in the 1 side table.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

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

    • Henryk's avatar
      Henryk
      Frequent Visitor
      4 years ago

      Hi,

      Thank You for reply, but I cannot chenge direction from single to both because I have only one table. And about "replace the field in the date range slicer with the field in the 1 side table" How can I do it. Can You explain it little bit?