How to get the cumulative total in the stacked column chart

[Haripinnoju]

Hi,

How to add the totals and display it in the stacked column chart with the help of the measure.

 

Expected output:

 

 As we see here initially the total count is 2 , in the next ,the total count is 3 , so the overall should be (2+3=5 which should be total ),next 1 (5+1=6 which should be the total for this line , instead of their individual totals, similarly for all the years it should be showing the cumulative totals in the graph. These are the count of suppliers by the year , split by the process.

Thank you in advance.

 

[Anonymous · Accepted solution]

Hi @Haripinnoju ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.

(2) We can create a measure.

Measure = CALCULATE(SUM('Table'[value]),FILTER(ALLSELECTED('Table'),'Table'[Year]<=MAX('Table'[Year])))

(3) Then the result is as follows.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[AilleryO]

Hi,

Maybe you can try make the calculation in a measure with a CALCULATE and ALL([column Process]) to remove the "filter" from Process which is splitting your number. If I understood well your information ?