Forum Discussion
Cumulative Sum based on column entries
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
Hi JLambs20 ,
Don't think you are using the correct format in the matrix.
Did you create the disconnected table with all the Versions ID? To what I can see you are using the version and the Included in Version columns on your model.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.