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!

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

I'm going to guess here that perhaps USERELATIONSHIP needs to be within the FILTER clause as well? Models like that are generally bad news. 

 

I wonder what would happen if you created 2 additional calendar tables so that you have 1 calendar table that relates to the other two and then each date in your table relates to one of those 2 calendar tables. Then you use the top calendar table date as your axis.

 

Then you would have all active relationships.