Creating ad stacked column chart with cumulative value.

[Anonymous]

Hi all,

how do i set up a DAX formula to be able to visualize a table as below with these columns;

ID	Column 1:	Column 2:
1	Planned	Planned date
2	Not planned
3	Actual	Actual date

BR Patrik

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Does your original data look like this? 

Then you need to select the ID column, then unpivot other columns.

Then remove the blank value.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I dont get it to work! Based on the data in table below, i would like to have the cummulative count, but the forumla only adds cumulative sum on the exact same date. What do i wrong?

What I want is to visualize how each row build up over time. (x-axis to show time and y-axis to show cumulative amount of IDs)

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

You need to remove the filter from the [a110] column, so try the following measure.

running total =
CALCULATE (
    COUNTA ( FRAS[a110] ),
    FILTER (
        ALLSELECTED ( FRAS ),
        ISONORAFTER ( FRAS[assignment_id], MAX ( FRAS[assignment_id] ), DESC )
    )
)

Best Regards,
Winniz

[Anonymous]

Perfect, thanks!

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Does your original data look like this? 

Then you need to select the ID column, then unpivot other columns.

Then remove the blank value.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[EraDon]

Hi Patrik,

I am not 100% sure about your question. I think this bar chart Y-axis is the count of IDs. Hope this is your fact table and it has repeating IDs for each plan. 
This is the normal cumulative DAX and you have to use the way you do counting IDs.

Cumulative Count IDs =

VAR maxdate = MAX('calendar'[Date])

Return

CALCULATE([countIDs], Filter(All('calendar'[Date]), 'calendar'[Date] <= maxdate))

[CountIDs] is the measure you need to get the number of IDs.

Now you can use Stack Chart X-axis is dates, values are [Cumulative Count IDs] and legend is Column 1 (plans type).

Regards