Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

cumulative line chart with nominal values

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.

Need Help

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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