Need help Creating chart with 2 commulative lines in power Bi

[yaseenhamid]

• -I am trying to create this in power Bi. 

-I m importing this data in excel. 

-after unpivoting columns other than first column . I'm getting this data in power Bi.

-to calculate commulative of planned and earned values over time. I'm using this formula to create measure. 

" Cumulative Total = 

CALCULATE (

SUM('scurve'[Cost]),

FILTER (

ALL( 'scurve'[Date] ),

'scurve'[Date] <= MAX ( 'scurve'[Date] )

))

" 

-Which calculates commulative for Planned and earned costs separately in same column.

 -the issue is that when I add these fields in chart to show what I want. It doesn't show me accurate commulative lines in chart. 

 

 - I want 2 lines showing commulative of planned and earned values here as I posted photo in the beginning of excel chart. 

[Arul · Accepted solution]

@yaseenhamid ,

use this measures,

Cumulative Earned Value = 
CALCULATE(
    SUM('Table'[Cost]),
    'Table'[Cost Type] = "Earned Value Cost",
    'Table'[Date]<=MAX('Table'[Date]))

Cumulative Planned Value = 
CALCULATE(
    SUM('Table'[Cost]),
    'Table'[Cost Type] = "Planned Value Cost",
    'Table'[Date]<=MAX('Table'[Date]))

Thanks,

Arul

[yaseenhamid]

Thanks for replying but this didnt solve the problem. I'm getting above posted results. I've give the link to excel file & Pbi file as well.   

https://1drv.ms/f/s!AtA5KhyKZ26ErWemIQKLBYToSrRp?e=QflE0L

[yaseenhamid]

Sorry. It worked when i removed heirarchies from date field. Would aapreciate if you could explain why this doenst work when date is in the form of heirarchies.