Cumulative measure & filters

[Julie_Ritt]

Hello everyone,

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.

Does someone have an idea how to resolve this ? 

Thank you. 

 

[Julie_Ritt]

@Greg_Deckler 

I'm using this, but it's a visual calculation

Running sum 1 = RUNNINGSUM([Field])

To give an example my data is consituated like this

Table one  planned documents

UniqueID    Week Number       Document Planned

    ID1                    1                              1

    ID2                    5                              1

    ID3                    3                              0

Table 2   real documents

UniqueID    Week Number       Real Document

    ID3                    1                              1

    ID2                    5                              0

    ID1                    3                              1

Table 3 ID list

Unique ID

     ID1

     ID2

     ID3

Table 4 Week number list

Week Number

    1

    2

    3

My table 3 and 4 are conected to the to others with 1 to many relation and are active

Document planned and Real document have only 1 or 0 as values.

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)

[Anonymous]

Hi @Julie_Ritt ,

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

[Greg_Deckler]

@Julie_Ritt What is your VC formula?