Forum Discussion
Cumulative Sum on Text Field
Anonymous
Please check the attached file:Running Total = CALCULATE( [Total Sales], 'Sales Table'[Priortiy] <= MAX( 'Priority Table'[Priority] ), ALLSELECTED( 'Priority Table' ) )
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?
Super UserAnonymous
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')
)https://drive.google.com/file/d/1k1M3yCb-4z1e_mF0hAT28SpeY3vdrX2P/view?usp=drive_link
Hi, if you look at Team B, there is 592 for one priority and one for a second one. I would expect the cumulative to be 592 until the next one kicks in to make it 1192. I need this to work with text though.- Fowmy
Anonymous
Please check the attached file:Running Total = CALCULATE( [Total Sales], 'Sales Table'[Priortiy] <= MAX( 'Priority Table'[Priority] ), ALLSELECTED( 'Priority Table' ) )
saudansariHelper II
Hi,
the shared file is different and does not reflect the number as you mentioned please share the file again. Create sample data and remove sensitive information.