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!

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
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
Frequent Visitor
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!