Avoid filtering cumulative sum

[TristanO216]

Hi,

I am trying to make a progess curve, using a cumulative sum. The point is to obtain a percentage of the finshied tasks over the total number of tasks.

This is easy using "Quick measures"; and this gives me the following DAX code :

Progress = 
CALCULATE(
	COUNTA('TASK'[TASK_PROGRESS]);
	FILTER(
		ALL('DATES'[Column1]);
		ISONORAFTER('DATES'[Column1]; MAX('DATES'[Column1]); DESC) 
    )
)

With

'TASK'[TASK_PROGRESS]

the percentage of progress in one task.

Now, the problem is, when I want to show this as a curve on a graph, if I filter the graph to focus on a particular period of time, the progress is filtered too. So it begins a 0% and ends at 100%.

I would like to knwo if it was possible not to "zoom" on a particular period of time without having an impact on the progress curve.

Thanks

Tristan

[v-cherch-msft]

Hi @TristanO216 

It seems you may use Edit interactions like below: The graph and the table would not be filtered by the slicer Primary Key.

Regards,

[TristanO216]

Hi @v-cherch-msft,

Thanks for you answer but that's not what I am looking for.

My "Progress" value must not impacted by the filter imposed by the slicer, contrary to the other data on my visual.

Some pictures will help me to explaine what I am looking for :

Here I have the complete period of time. The progress is starting at 0%, and ends at 100%,.

After applying a filter in time, my progress is still beginning at 0% and ends at 100%.

My goal is that my progress curve follows the actual value, based on the 2015-2019 period, and not on the only on the 2016 period.

Thanks for your help

Tristan

[v-cherch-msft]

Hi @TristanO216 

Show a simple sample here.You may try to create a Month table and use it as x-axis.Create the second same data table to get the sales.Link them as below.Then the different slicers could change different lines.Please refer to below attached simple file.

Regards

[v-cherch-msft]

Hi @TristanO216 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

Regards,