Cumulative sum ignoring starting date of filter

[gutierres]

 think I have a simple question, but I'm currently stuck. I uploaded an example file here: https://ufile.io/7iv97 I want the graph to show a cumulative sum, the thing is: It should calculate from the beginning of the data source until the date on the filter. The problem is: When my filter does not cover the data since the beginning, the cumulative sum is calculated since the starting date of the filter (I want the cumulative sum to ignore it) I guess this is simple but I couldnt solve it, so I made a simple example to make it easier to answer my question.

It shows 25 when the filter covers the entire period, but less when I move the filter beyond the starting date: 

[v-lili6-msft]

Hi@gutierres

You can try to use Edit interactions function.Visual interactions can be used to change how visualizations on a report page impact each other

Step 1:

Select slicer visualization to make it active.

Step 2:

select Format > Interactions.

Step 3:

To turn on the visualization interaction controls, select Edit interactions. Power BI adds cross-filter and cross-highlight icons to all of the other visualizations on the report page

Step 4:

Determine what impact the selected visualization should have on the others. And, optionally, repeat for all other visualizations on the report page.

Reference: https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Best Regards,

Lin

[gutierres]

Hello Lin, thanks for answering.

I tried the Edit Interactions but it didn't work. I think I have to change the dax formula, because the problem is that the cumulative value changes with the starting date on the filter, but I have to make it calculate the cumulative sum independently from the starting date, only considering the ending date. The problem is that I didn't manage to formulate a DAX formula to represent that.

[v-lili6-msft]

Hi@gutierres

You can try to set the type of slicer  by selecting "Before"  in the upper-right corner drop-down box  which you pull the field DATA_LEVANTAMENTO,

then your measure medida and  medida 2 will show the cumulative sum from  the beginning of the data source to the date on the slicer you selected.

Best Regards,

Lin