Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Stack area chart with cumulative

Hi there,   Could any one help me understand where my mistake is and how to fix it? I'm trying to depicture how our team has been dealing with issues over time (number of issues created vs number o...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    7 years ago

    Hi Anonymous ,

     

    By my test, you need to modify the measure. The following is my sample you reference.

     

    I have two tables. The table of Date is a calendar table. And there is a many-to-one relationship between them.

    Date = CALENDARAUTO()

    Measure = var a = CALCULATE(SUM(Table1[column]),FILTER(ALL('Date'),'Date'[Date]<=MAX('Date'[Date])))

    var b = CALCULATETABLE(VALUES('Table1'[Date]),ALLSELECTED(Table1))

    return

    IF(MAX('Date'[Date]) in b,a,BLANK())

     

    Note : You have to add the column of Date from the calendar table to Matrix, not the Date from others.

    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.

v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi Anonymous ,

 

By my test, you need to modify the measure. The following is my sample you reference.

 

I have two tables. The table of Date is a calendar table. And there is a many-to-one relationship between them.

Date = CALENDARAUTO()

Measure = var a = CALCULATE(SUM(Table1[column]),FILTER(ALL('Date'),'Date'[Date]<=MAX('Date'[Date])))

var b = CALCULATETABLE(VALUES('Table1'[Date]),ALLSELECTED(Table1))

return

IF(MAX('Date'[Date]) in b,a,BLANK())

 

Note : You have to add the column of Date from the calendar table to Matrix, not the Date from others.

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

    thanks a lot for your help, v-xuding-msft. It worked perfectly