Forum Discussion

PBI_User1's avatar
PBI_User1
New Member
8 years ago
Solved

Measure doesn't work as expected

Hi, I'm trying to create a Measure to do an incremental sum. Cost running total in Date = CALCULATE( SUM('JobDocs'[Cost]); FILTER( ALLSELECTED('JobDocs'[Date]); ISONORAFTER('JobDocs'[Date]; MAX...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi PBI_User1,

     

    Try this formula please.

     

    Cost running total in Date =
CALCULATE (
    SUM ( 'JobDocs'[Cost] );
    FILTER ( ALL ( 'JobDocs' ); 'JobDocs'[Date] <= MAX ( 'JobDocs'[Date] ) )
)

    Best Regards,

    Dale

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi PBI_User1,

 

Try this formula please.

 

Cost running total in Date =
CALCULATE (
    SUM ( 'JobDocs'[Cost] );
    FILTER ( ALL ( 'JobDocs' ); 'JobDocs'[Date] <= MAX ( 'JobDocs'[Date] ) )
)

Best Regards,

Dale