Stacked area chart don't work when filter apply

[Anonymous]

Hello, I have a Stacked area chart, from a Table like this 

A 1

B -1

A 1

B -1

A 1

And it sums all the value in the date

But when i apply a filter, it looks like this 

I want that the lines overlips like in the first picture ... 

My DAx formula for this chart is :

VAR varDate = SELECTEDVALUE(Table[Data.ChangedDate])

VAR varState = SELECTEDVALUE(Table[State])

RETURN

    CALCULATE(

        SUM(Table[Value],

        Table[Data.ChangedDate] <= varDate

            && Table[State] = varState

    )

The filter that make an issue is in the table and it's a column called "Version"

Thank you in advance for helping ...

[Anonymous]

I think the DAX measure is the cause

Because it's with this measure that there is a problem 

[Anonymous]

I also noticed that in the visual filtered with Power Query, there is "0 5 0 0 2" in the tooltip of a date for example

But in the visual made with the slicer, there is only 5 2 (0 are omitted) 

I tried +0 at the end of the formula but it doesn't work

[Anonymous]

I don't think the date table is the problem ...

[Anonymous]

Curious thing but on the visual with Power Query (who is filtered with the value of Version) 

When i use a segment and click on it (the only segment of the version that i can click), the visual change and have the form that i don't want ... It's the use of the segment in the filter that affect the visual

[Anonymous]

When i filter the version in Power Query, it works ...

[AlexisOlson]

Given this difference in behavior, I suspect you are having an issue arising from "auto-exist" internal logic. The fix for this is to use a proper star schema. In particular, I think using a date dimension table would help resolve this.

[Anonymous]

I have a date table but in the DAX formula when i use the date table instead of the Data.ChangedDate, it don't works ...