Forum Discussion

JLambs20's avatar
JLambs20
Icon for Helper III rankHelper III
5 years ago

Cumulative Sum based on column entries

Hello! I have a table of information that i'll show in Excel in order to understand it better.  Essentially, I need to get a cumulative sum, in a table, of time saved based on a current version (alon...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

Hi JLambs20 ,

 

Create a disconnected table with the versions.

Add the following measure to your model:

Timesaved =
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[Version],
        "@TimeSaved",
            IF (
                SELECTEDVALUE ( 'Table'[Version] ) <= SELECTEDVALUE ( Versions[Version] ),
                SUM ( 'Table'[Time Saved] )
            )
    ),
    [@TimeSaved]
)

 

Create the matrix in the following way:

  • Rows:
    • Version[Version]
    • TimeSavedTable[Version]
  • Values
    • Timessaved (measure)

 

 

 

Now create the 

JLambs20's avatar
JLambs20
Icon for Helper III rankHelper III
5 years ago

Hello Miguel and thank you for taking the time to respond. Unfortunately, your solution didn't quite get me there.  I created the version table and the measure, but my values were not displaying as I need them to.  I'm going to add some more screenshots to show you more specifically what I needed. This first one is an extract of my data table in BI (exported to Excel) just to show you exactly what I'm working with.  The whole idea is for an end user to be able to select a version from a slicer and then show that version along with all of the versions included in that one (which are manually selected in the original raw data) in a table with total hours saved per version (with the total rolling up).  Here is the extract:

Here is 

Here is the resulting Matrix in BI:

 

As you can see, I also have the issue of getting each of those versions onto their own row to show individual summary hours. 

 

Again I appreciate all of your help. 

 

Regards,

Josh