Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Cumulative Sum on Text Field

Hi, I am trying to present a cumulative sum by priority and project with the two being a concatenated field in a separate table.   Example. (Priority Initiative) 1-Warehouse 2-Field 3-Retail 1...
Need Help
  • Fowmy's avatar
    Fowmy
    2 years ago

    Anonymous 

    Please check the attached file:

    Running Total = 
CALCULATE(
    [Total Sales],
    'Sales Table'[Priortiy] <= MAX( 'Priority Table'[Priority] ),
    ALLSELECTED( 'Priority Table' )   
)

     

     


     

Fowmy's avatar
Fowmy
Super User
2 years ago

Anonymous 

Modify your measure as follows. I assume you have includedonly the 'Priority Intiative'[Priority Int] on the Row section of the matrix, that's way I removed the filters using REMOVEFILTER, if you have added more columns from the same table, please include them as well.



Running Total = 
CALCULATE(
   sum( Sales[Total Sales]),
      'Priority Intiative'[Priority] <=  MAX('Priority Intiative'[Priority]),
      REMOVEFILTERS( 'Priority Intiative'[Priority Int] )      
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks!  I am still runnning into this thing where it doesn't carry the value down. My Priority table only has the Int field and the priority number.  Any thoughts? 

     

    • Fowmy's avatar
      Fowmy
      Super User
      2 years ago

      Anonymous 

      Try this measure, if it doesn't work, please share a dummy PBI file that represents your secenario. Save it in Google Drive and share the link here.

      Running Total = 
CALCULATE(
   sum( Sales[Total Sales]),
      'Priority Intiative'[Priority] <=  MAX('Priority Intiative'[Priority]),
      REMOVEFILTERS( 'Priority Intiative')      
)