topic Re: How to get the cumulative total in the stacked column chart in DAX Commands and Tips

How to get the cumulative total in the stacked column chart

Haripinnoju — Tue, 17 Oct 2023 12:12:04 GMT

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.

Re: How to get the cumulative total in the stacked column chart

AilleryO — Tue, 17 Oct 2023 13:13:30 GMT

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 ?

Re: How to get the cumulative total in the stacked column chart

Anonymous — Thu, 19 Oct 2023 03:14:34 GMT

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.