Wrong cumulative sum in Power BI

[Analitika]

Hi, 

I can't calculate properly cumulative sum in Power BI. I am getting different numbers as not expexted:

CF vaizdavimas Investicine kaupimas = 
IF (
    CONTAINS ( 'Pasirinkti_CF', 'Pasirinkti_CF'[Parinkimas], "Investicinė veikla (sukaupta)" ),
CALCULATE ([Pinigu srautas], FILTER ( ALLSELECTED ( 'Date'), 'Date'[Date] <= MAX ( 'Date'[Date] ) ), FILTER('N01_KODAS_SS','N01_KODAS_SS'[Sask_kod_info.Pinigu srautui_2]="Pinigų srautas iš investicinės veiklos")),
    BLANK ()
)

Here is a cumulative function.

it sums not correctly somehow.

Total should be 

but it is in visual: -135,378

[Fowmy]

@Analitika 

Please apply the following DAX measure and try

CF vaizdavimas Investicine kaupimas =
VAR __Date =
    MAX ( 'Date'[Date] )
RETURN
    IF (
        CONTAINS (
            'Pasirinkti_CF',
            'Pasirinkti_CF'[Parinkimas], "Investicinė veikla (sukaupta)"
        ),
        CALCULATE (
            [Pinigu srautas],
            'Date'[Date] <= __Date,
            'N01_KODAS_SS'[Sask_kod_info.Pinigu srautui_2] = "Pinigų srautas iš investicinės veiklos",
            ALLSELECTED ( 'Date' )
        )
    )

[Analitika]

Marked value in table is correct but in visual shows nonsense:

[Fowmy]

@Analitika 

Wihout being able to see your model, the calculations and how you have applied filters, it's hard to suggest a solution. Please share an example file that show the issue you are facing.

[Analitika]

Hi,

Here cumulative sum will 832400. 

But when I see in visual I see -867, 600

[Analitika]

[PaulDBrown]

Please share sample non-confidential data or PBIX file

[Analitika]

I don't have it.