Create a Measure which Returns a Certain Value from a Cumulative Measure

[Anonymous]

Hi! I wanted to create a measure which will return a specific value which is computed using a cumulative total. For example, I only want to get the Cumulative Target for Week 5 which is 2064. Note again that Cumulative Target is a calculated measure and not a calculated column. Is there a way to create a measure such as this?

Thank you!

[Phil_Seamark · Accepted solution]

Hi @Anonymous

This worked for me and I have attached a basic PBIX file.

Measure = CALCULATE([Cumulative Target],'Table1'[Week]="Week 5")

[Phil_Seamark · Accepted solution]

Hi @Anonymous

This worked for me and I have attached a basic PBIX file.

Measure = CALCULATE([Cumulative Target],'Table1'[Week]="Week 5")

[Anonymous · Accepted solution]

Figured it out. I just have to use <= instead of an equal sign for the Week in Measure. Thanks a lot @Phil_Seamark 

Measure = CALCULATE([Cumulative Target],'Table1'[Week] <= "Week 5")

[Anonymous]

Hi @Phil_Seamark,

Thanks for the fast response ! 

But I'm still having trouble. Using the formula, the measure returns the Target not the Cumulative Target.

Here's my formula for the Cumulative Target:

Cumulative Target= 
    CALCULATE( SUM( 'Table'[Target] ),
               FILTER( ALLSELECTED( 'Table' ),
                       'Table'[Week Number] <= MAX( 'Table'[Week Number] )
               ))

I have another column in my table which is the Week Number.