Cumulative measure & filters

Question

Hello everyone,&nbsp;&nbsp;I created a graph, like you can see on the picture. I created the 2 curve by using the command "New visual calculation - Running sum" Everything is working well until I Try to apply filters on my graph ( The blue bars are adapting correctly) . I can Imagine that it is because the running sum is calculated before the the filters and it does not update the values. I also added the tab version of my graph.&nbsp;Does someone have an idea how to resolve this ?&nbsp;&nbsp;Thank you.&nbsp;&nbsp;&nbsp;&nbsp;

greg_deckler · Answer

Julie_Ritt&nbsp;What is your VC formula?

julie_ritt · Answer

Greg_Deckler&nbsp;I'm using this, but it's a visual calculationRunning sum 1 = RUNNINGSUM([Field])&nbsp;&nbsp;To give an example my data is consituated like this&nbsp;Table one&nbsp; planned documentsUniqueID&nbsp; &nbsp; Week Number&nbsp; &nbsp; &nbsp; &nbsp;Document Planned&nbsp; &nbsp; ID1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; ID2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; ID3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp;&nbsp;Table 2&nbsp; &nbsp;real documentsUniqueID&nbsp; &nbsp; Week Number&nbsp; &nbsp; &nbsp; &nbsp;Real Document&nbsp; &nbsp; ID3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; ID2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; ID1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp;Table 3 ID listUnique ID&nbsp; &nbsp; &nbsp;ID1&nbsp; &nbsp; &nbsp;ID2&nbsp; &nbsp; &nbsp;ID3&nbsp;Table 4 Week number listWeek Number&nbsp; &nbsp; 1&nbsp; &nbsp; 2&nbsp; &nbsp; 3&nbsp;&nbsp;&nbsp;My table 3 and 4 are conected to the to others with 1 to many relation and are activeDocument planned and Real document have only 1 or 0 as values.&nbsp;The blue bars are working well and I just want my curve to make the cumulative sum of what appears on the graph. I have maybe 4 or 5 filters that can be applied by the viewer and they must adapt the curve as well ( they modify only the bars for the moment)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Julie_Ritt&nbsp;,
Base on the sample data in your last reply, what's the expected result? How did you set your visual? Could you please update the info(visual settings, expected result etc.) in the attached pbix file? Thank you.
Best Regards

Forum Discussion

Cumulative measure & filters

3 Replies

Related content

Cumulative Measure

Cumulative Total

Cumulative Difference from Another measure

Cumulative measure / 100

Transform measure in cumulative measure