Forum Discussion

TristanO216's avatar
TristanO216
Frequent Visitor
7 years ago

Avoid filtering cumulative sum

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

Need Help

4 Replies

    • TristanO216's avatar
      TristanO216
      Frequent Visitor
      7 years ago

      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's avatar
        v-cherch-msft
        Microsoft Employee
        7 years ago

        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