Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

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 ag...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi Anonymous

     

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

     

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

  • Anonymous's avatar
    Anonymous
    8 years ago

     

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

     

     

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

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi Anonymous

 

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

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

     

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

     

     

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

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Phil_Seamark,

     

    Thanks for the fast response :smileyhappy:! 

     

    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.