Forum Discussion

kdumas's avatar
kdumas
Frequent Visitor
9 years ago

Events on Cumulation

Good morning all,

 

I am trying to solve an issue I'm having which is to plot critical milestones over a cumulative amount measure on some sort of time phased line chart. Currently, the milestones and the data from the cumulative measure are in two separate tables with a date relationship to a central Date Table.

 

Right now I'm trying to utilize the pulse chart but when I add the milestones onto the "Event Description" I get a separate entry in the data of every single milestone on every single date. So the data looks like the following if I had milestones of A, B, C:

 

January 1st 2017, A

January 1st 2017, B

January 1st 2017, C

January 2nd 2017, A

January 2nd 2017, B

January 2nd 2017, C

 

The expression I am using for my cumulation is the following:

 

At-Risk = CALCULATE(sumx(filter(SubEvents,SubEvents[Subevent At Risk Date] >= SubEvents[Subevent Due Date]),SubEvents[Amount At-Risk]),FILTER(ALLSELECTED(SubEvents),SubEvents[Subevent At Risk Date] <= MAX(DimDate[DateKey])))

 

Thank you all and let me know if you need any more information that would help!

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi kdumas,

     

    Please provide some detailed sample data stored in each table so that I can better understand your measure and test for you. Also, what is your desired result? Please illustrate your scenario with examples.

     

    Best regards,
    Yuliana Gu