Forum Discussion

JPQ's avatar
JPQ
Frequent Visitor
7 years ago
Solved

Two Cumulative Totals in the same graph

Hi,   After a lot of reading, i´m still managing a problem inserting two measures for cumulative totals in the same graph. I have a table with two date columns (Dta.CONF, Liberacao Real) both rela...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi JPQ,

     

    Your formulas should work though the result could be wrong. Please try this formula instead and the demo in the attachment.

    Liberado Acumulado new =
CALCULATE (
    SUM ( 'IW39 Filtrada'[Custos tot.plan] ),
    FILTER ( ALLSELECTED ( 'Datas'[Date] ), 'Datas'[Date] <= MAX ( 'Datas'[Date] ) ),
    USERELATIONSHIP ( Datas[Date], 'IW39 Filtrada'[Liberação real] )
)

    Two-Cumulative-Totals-in-the-same-graph

     

    Best Regards,
    Dale

  • JPQ's avatar
    JPQ
    7 years ago

    hi v-jiascu-msft

     

    Thx for the tip!

    I finally works. The only thing is that it projets the upcoming months.

    Thx a lot!

JPQ's avatar
JPQ
Frequent Visitor
7 years ago

Hi ,

 

Thx for the answer. It seems that USERELATIONSHIP can only be apllied to the CALCULTE function.

I tried to set the date hierarchy that you mentioned, but one of the relationships came inactive.

I found out that one way to solve this problem is duplicating the data table and establishing two active relationships to the calendar table. It solves the problem, but i'm not happy with it.