cumulative line chart with nominal values

[Anonymous]

Hi,

I 've got problem with creating cumulative line chart. The variable has nominal values between 0 and 10 and I want to create a chart with share of nominal values in such a pattern:

if value equals 0 this observation is only in 0,

if value equals 1 this observation is in 1 and 0,

if value equals 2 this observation is in 2, 1 and 0,

... etc

if value equals 10 this observation is in 10,9,8,7,6,5,4,3,2,1,0 (in all)

The following plot contains shares of distinct values, I want to accumulate values according to described pattern.

[v-xuding-msft]

Hi @Anonymous ,

Do you want to calculate cumulative share of observation? If so, you can reference my sample to modify yours.

Measure = CALCULATE(SUM(Table1[share]),FILTER(ALL(Table1),Table1[values] <= MAX(Table1[values])))

If I understand incorrectly , please post some sample data and excepted output. Then we can help you as soon as possible.

Best Regards,

Xue Ding 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Almost good, but in opposite way 🙂

In zero's should be all values - from 0 to 10, 

in 1 all except 0,

in 2 all except 0 and 1

...

in 9 only 9 and 10

and in 10 only ten's