Show blank values in a cumulative bar chart

[uxorise3424]

Hi everyone. I have been working on a bar chart that is cumulative and I have been able to figue that out but i need help filling in some gaps. 

Here is what my chart looks like right now:

And here is the equation i am using: 

CALCULATE(

    COUNT('Query1'[EV3]),

    FILTER(

        ALLSELECTED('Query1'),

        ISONORAFTER('Query1'[EV3)],MAX('Query1'[EV3]),DESC)

    )

)

So in the chart you can see a bar for 400, 450, 500, then 600. It skips over 550 becuase there are no values that fall in that range. Since this is supposed to be cumulative, is there a way to just make it equal to the last bar?

Clarifications about the data

EV3 is the X-Axis which is just a number a person chose (200, 250, 300, etc.) and the bars are the % of people that choose that number including all the ones lower.

Thank you!

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but try getting the X-axis from dimension table, not from the same table as the fact table. And also, use the dimension table in the measure.