Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
GuustD
Helper I
Helper I

Dynamic Cumulative Sum

Hi!

I´ve really searched all over the place and can´t find the answer to what I thought would be a simple business case:

 

I want to create a cumulative sum that accumulates depending on the sorting that is done by the user of the chart/table. There are four categories (A,B,C,D) and the user sorts the graph in ascending order by those categories. In that case I would like to my measure to contain;

- Category A = the total of category A

- Category B = the total of category A and B

- Category C = the total of category A, B and C

- Category D = the total of category A, B, C and D

 

But now the user sorts the graph in a different way, namely descending by category. Now I would like my measure to contain;

- Category D = the total of category D

- Category C = the total of category D and C

- Category B = the total of category D, C and B

- Category A = the total of category D, C, B and A

 

How can I achieve this? So far all solutions contain some kind of pre-defined ordering (line an index or rank or value). I just want to accumulate from left to right (in my graph) no matter the sorting that I use in my graph, using one measure. Any help would be greatly appreciated!

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey,

 

unfortunately this is not possible.

This is due to the fact that a measure is not aware of the sorting of the axis in the visual.

 

For this reason, you might consider to provide a solution to your users that is build on bookmarks, where you use two different visuals where each is using a different measure.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi, 

Did you find solution for your problem?  I am working on the similar situation, want my cummalitive value to be dynamic irrespective of way the value sort, the cummalitive value has to be in ascending order. Any help would be appreciated. 

Hi Shikha,

After I got the answer that it wasn´t possible I gave up on this subject so I´m sorry to say I can´t help you with this. Should you find the solution to this this problem I´m all ears!

Kind regards,

Guust

TomMartens
Super User
Super User

Hey,

 

unfortunately this is not possible.

This is due to the fact that a measure is not aware of the sorting of the axis in the visual.

 

For this reason, you might consider to provide a solution to your users that is build on bookmarks, where you use two different visuals where each is using a different measure.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi Tom,

For some reason I thought this would be possible, but your explanation makes sense.

Thanks a lot for your answer. I will will stop my quest for now 🙂

Kind regards,

Guust

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.